{ "cells": [ { "cell_type": "code", "execution_count": 30, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "df = pd.read_excel('https://query.data.world/s/ivl45pdpubos6jpsii3djsjwm2pcjv', skiprows=5)" ] }, { "cell_type": "code", "execution_count": 31, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
DRG DefinitionProvider IdProvider NameProvider Street AddressProvider CityProvider StateProvider Zip CodeHospital Referral Region (HRR) DescriptionTotal DischargesAverage Covered ChargesAverage Total PaymentsAverage Medicare Payments
0001 - HEART TRANSPLANT OR IMPLANT OF HEART ASS...10033UNIVERSITY OF ALABAMA HOSPITAL619 SOUTH 19TH STREETBIRMINGHAMAL35233AL - Birmingham131.172866e+06251876.307692244457.923077
1001 - HEART TRANSPLANT OR IMPLANT OF HEART ASS...30103MAYO CLINIC HOSPITAL5777 EAST MAYO BOULEVARDPHOENIXAZ85054AZ - Phoenix204.375313e+05240422.800000133509.550000
2001 - HEART TRANSPLANT OR IMPLANT OF HEART ASS...50108SUTTER GENERAL HOSPITAL2801 L STREETSACRAMENTOCA95816CA - Sacramento258.156741e+05233197.480000221681.800000
3001 - HEART TRANSPLANT OR IMPLANT OF HEART ASS...50262RONALD REAGAN U C L A MEDICAL CENTER757 WESTWOOD PLAZALOS ANGELESCA90095CA - Los Angeles141.499044e+06415968.785714366608.928571
4001 - HEART TRANSPLANT OR IMPLANT OF HEART ASS...50441STANFORD HOSPITAL300 PASTEUR DRIVESTANFORDCA94305CA - San Mateo County232.238699e+06420865.478261403453.652174
\n", "
" ], "text/plain": [ " DRG Definition Provider Id \\\n", "0 001 - HEART TRANSPLANT OR IMPLANT OF HEART ASS... 10033 \n", "1 001 - HEART TRANSPLANT OR IMPLANT OF HEART ASS... 30103 \n", "2 001 - HEART TRANSPLANT OR IMPLANT OF HEART ASS... 50108 \n", "3 001 - HEART TRANSPLANT OR IMPLANT OF HEART ASS... 50262 \n", "4 001 - HEART TRANSPLANT OR IMPLANT OF HEART ASS... 50441 \n", "\n", " Provider Name Provider Street Address \\\n", "0 UNIVERSITY OF ALABAMA HOSPITAL 619 SOUTH 19TH STREET \n", "1 MAYO CLINIC HOSPITAL 5777 EAST MAYO BOULEVARD \n", "2 SUTTER GENERAL HOSPITAL 2801 L STREET \n", "3 RONALD REAGAN U C L A MEDICAL CENTER 757 WESTWOOD PLAZA \n", "4 STANFORD HOSPITAL 300 PASTEUR DRIVE \n", "\n", " Provider City Provider State Provider Zip Code \\\n", "0 BIRMINGHAM AL 35233 \n", "1 PHOENIX AZ 85054 \n", "2 SACRAMENTO CA 95816 \n", "3 LOS ANGELES CA 90095 \n", "4 STANFORD CA 94305 \n", "\n", " Hospital Referral Region (HRR) Description Total Discharges \\\n", "0 AL - Birmingham 13 \n", "1 AZ - Phoenix 20 \n", "2 CA - Sacramento 25 \n", "3 CA - Los Angeles 14 \n", "4 CA - San Mateo County 23 \n", "\n", " Average Covered Charges Average Total Payments Average Medicare Payments \n", "0 1.172866e+06 251876.307692 244457.923077 \n", "1 4.375313e+05 240422.800000 133509.550000 \n", "2 8.156741e+05 233197.480000 221681.800000 \n", "3 1.499044e+06 415968.785714 366608.928571 \n", "4 2.238699e+06 420865.478261 403453.652174 " ] }, "execution_count": 31, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.head()" ] }, { "cell_type": "code", "execution_count": 32, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "DRG Definition object\n", "Provider Id int64\n", "Provider Name object\n", "Provider Street Address object\n", "Provider City object\n", "Provider State object\n", "Provider Zip Code int64\n", "Hospital Referral Region (HRR) Description object\n", "Total Discharges int64\n", "Average Covered Charges float64\n", "Average Total Payments float64\n", "Average Medicare Payments float64\n", "dtype: object" ] }, "execution_count": 32, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.dtypes" ] }, { "cell_type": "code", "execution_count": 33, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Provider IdProvider Zip CodeTotal DischargesAverage Covered ChargesAverage Total PaymentsAverage Medicare Payments
count202656.000000202656.000000202656.0000002.026560e+05202656.000000202656.000000
mean255322.55274947029.14169836.0111965.258934e+0413168.56014411218.465217
std150834.20355027792.93543348.8648356.244522e+0413772.83967112279.103622
min10001.0000001040.00000011.0000001.367652e+032320.4827591329.909091
25%110082.00000025301.00000014.0000002.094930e+046258.9258065011.979167
50%240093.00000043701.00000022.0000003.463380e+049180.1697537714.654762
75%380014.00000071603.00000039.0000006.076193e+0414631.46669012472.680288
max670088.00000099801.0000003855.0000002.238699e+06434396.000000403453.652174
\n", "
" ], "text/plain": [ " Provider Id Provider Zip Code Total Discharges \\\n", "count 202656.000000 202656.000000 202656.000000 \n", "mean 255322.552749 47029.141698 36.011196 \n", "std 150834.203550 27792.935433 48.864835 \n", "min 10001.000000 1040.000000 11.000000 \n", "25% 110082.000000 25301.000000 14.000000 \n", "50% 240093.000000 43701.000000 22.000000 \n", "75% 380014.000000 71603.000000 39.000000 \n", "max 670088.000000 99801.000000 3855.000000 \n", "\n", " Average Covered Charges Average Total Payments \\\n", "count 2.026560e+05 202656.000000 \n", "mean 5.258934e+04 13168.560144 \n", "std 6.244522e+04 13772.839671 \n", "min 1.367652e+03 2320.482759 \n", "25% 2.094930e+04 6258.925806 \n", "50% 3.463380e+04 9180.169753 \n", "75% 6.076193e+04 14631.466690 \n", "max 2.238699e+06 434396.000000 \n", "\n", " Average Medicare Payments \n", "count 202656.000000 \n", "mean 11218.465217 \n", "std 12279.103622 \n", "min 1329.909091 \n", "25% 5011.979167 \n", "50% 7714.654762 \n", "75% 12472.680288 \n", "max 403453.652174 " ] }, "execution_count": 33, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.describe()" ] }, { "cell_type": "code", "execution_count": 38, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "564" ] }, "execution_count": 38, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[\"DRG Definition\"].unique().size" ] }, { "cell_type": "code", "execution_count": 39, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "3151" ] }, "execution_count": 39, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[\"Provider Name\"].unique().size" ] }, { "cell_type": "code", "execution_count": 41, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "DRG Definition 0\n", "Provider Id 0\n", "Provider Name 0\n", "Provider Street Address 0\n", "Provider City 0\n", "Provider State 0\n", "Provider Zip Code 0\n", "Hospital Referral Region (HRR) Description 0\n", "Total Discharges 0\n", "Average Covered Charges 0\n", "Average Total Payments 0\n", "Average Medicare Payments 0\n", "dtype: int64" ] }, "execution_count": 41, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.isna().sum()" ] }, { "cell_type": "code", "execution_count": 42, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "51" ] }, "execution_count": 42, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[\"Provider State\"].unique().size" ] }, { "cell_type": "code", "execution_count": 45, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "array(['AL', 'AZ', 'CA', 'CT', 'DC', 'FL', 'GA', 'IL', 'IN', 'KY', 'LA',\n", " 'MA', 'MI', 'MN', 'MO', 'NE', 'NJ', 'NY', 'NC', 'OH', 'OK', 'PA',\n", " 'SC', 'TN', 'TX', 'VA', 'WA', 'WI', 'AK', 'AR', 'CO', 'DE', 'ID',\n", " 'IA', 'KS', 'ME', 'MD', 'MS', 'NV', 'NH', 'NM', 'ND', 'OR', 'RI',\n", " 'UT', 'VT', 'WV', 'HI', 'SD', 'MT', 'WY'], dtype=object)" ] }, "execution_count": 45, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[\"Provider State\"].unique()" ] }, { "cell_type": "code", "execution_count": 52, "metadata": {}, "outputs": [], "source": [ "most_common = df.groupby(\"DRG Definition\")[\"Total Discharges\"].sum().sort_values(ascending=False).iloc[:20]" ] }, { "cell_type": "code", "execution_count": 54, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "array(['470 - MAJOR JOINT REPLACEMENT OR REATTACHMENT OF LOWER EXTREMITY W/O MCC',\n", " '871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV 96+ HOURS W MCC',\n", " '291 - HEART FAILURE & SHOCK W MCC',\n", " '292 - HEART FAILURE & SHOCK W CC',\n", " '392 - ESOPHAGITIS, GASTROENT & MISC DIGEST DISORDERS W/O MCC',\n", " '690 - KIDNEY & URINARY TRACT INFECTIONS W/O MCC',\n", " '194 - SIMPLE PNEUMONIA & PLEURISY W CC',\n", " '683 - RENAL FAILURE W CC', '378 - G.I. HEMORRHAGE W CC',\n", " '872 - SEPTICEMIA OR SEVERE SEPSIS W/O MV 96+ HOURS W/O MCC',\n", " '190 - CHRONIC OBSTRUCTIVE PULMONARY DISEASE W MCC',\n", " '193 - SIMPLE PNEUMONIA & PLEURISY W MCC',\n", " '603 - CELLULITIS W/O MCC',\n", " '189 - PULMONARY EDEMA & RESPIRATORY FAILURE',\n", " '191 - CHRONIC OBSTRUCTIVE PULMONARY DISEASE W CC',\n", " '682 - RENAL FAILURE W MCC',\n", " '641 - MISC DISORDERS OF NUTRITION,METABOLISM,FLUIDS/ELECTROLYTES W/O MCC',\n", " '065 - INTRACRANIAL HEMORRHAGE OR CEREBRAL INFARCTION W CC OR TPA IN 24 HRS',\n", " '309 - CARDIAC ARRHYTHMIA & CONDUCTION DISORDERS W CC',\n", " '885 - PSYCHOSES'], dtype=object)" ] }, "execution_count": 54, "metadata": {}, "output_type": "execute_result" } ], "source": [ "most_common.index.values" ] }, { "cell_type": "code", "execution_count": 102, "metadata": {}, "outputs": [], "source": [ "total_discharges = df.groupby([\"DRG Definition\", \"Provider State\"])[\"Total Discharges\"].sum().unstack()" ] }, { "cell_type": "code", "execution_count": 103, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "DRG Definition\n", "001 - HEART TRANSPLANT OR IMPLANT OF HEART ASSIST SYSTEM W MCC 1495.0\n", "002 - HEART TRANSPLANT OR IMPLANT OF HEART ASSIST SYSTEM W/O MCC 23.0\n", "003 - ECMO OR TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH & NECK W MAJ O.R. 11987.0\n", "004 - TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH & NECK W/O MAJ O.R. 11774.0\n", "005 - LIVER TRANSPLANT W MCC OR INTESTINAL TRANSPLANT 741.0\n", "Name: Total, dtype: float64" ] }, "execution_count": 103, "metadata": {}, "output_type": "execute_result" } ], "source": [ "total_discharges.fillna(0, inplace = True)\n", "total_discharges[\"Total\"] = total_discharges.sum(axis = 1)\n", "total_discharges[\"Total\"].head()" ] }, { "cell_type": "code", "execution_count": 104, "metadata": {}, "outputs": [], "source": [ "total_discharges.sort_values(by = \"Total\", ascending=False, inplace = True)" ] }, { "cell_type": "code", "execution_count": 105, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Provider StateAKALARAZCACOCTDCDEFL...TNTXUTVAVTWAWIWVWYTotal
DRG Definition
470 - MAJOR JOINT REPLACEMENT OR REATTACHMENT OF LOWER EXTREMITY W/O MCC855.09146.05692.010472.032930.07793.05689.01247.02119.031086.0...11133.029410.04455.013923.0766.010027.09482.02925.0651.0458259.0
871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV 96+ HOURS W MCC452.06066.05187.06914.045434.04400.06390.0643.01556.025209.0...11295.030595.02780.015119.0739.010146.06712.03427.0474.0438597.0
291 - HEART FAILURE & SHOCK W MCC110.03894.02143.02252.014894.01273.02806.0529.01019.014923.0...5285.013718.0500.06815.0303.03557.03028.01535.0161.0198889.0
292 - HEART FAILURE & SHOCK W CC166.04131.02382.02092.011654.01341.02714.0902.0936.014274.0...4899.013047.0548.05863.0318.02900.03175.01749.0212.0192918.0
392 - ESOPHAGITIS, GASTROENT & MISC DIGEST DISORDERS W/O MCC182.04920.02462.03050.012358.01728.02723.0556.0782.020322.0...4681.012692.0492.04884.0249.02435.02582.01632.0168.0190375.0
\n", "

5 rows × 52 columns

\n", "
" ], "text/plain": [ "Provider State AK AL AR \\\n", "DRG Definition \n", "470 - MAJOR JOINT REPLACEMENT OR REATTACHMENT O... 855.0 9146.0 5692.0 \n", "871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV 96+ HO... 452.0 6066.0 5187.0 \n", "291 - HEART FAILURE & SHOCK W MCC 110.0 3894.0 2143.0 \n", "292 - HEART FAILURE & SHOCK W CC 166.0 4131.0 2382.0 \n", "392 - ESOPHAGITIS, GASTROENT & MISC DIGEST DISO... 182.0 4920.0 2462.0 \n", "\n", "Provider State AZ CA CO \\\n", "DRG Definition \n", "470 - MAJOR JOINT REPLACEMENT OR REATTACHMENT O... 10472.0 32930.0 7793.0 \n", "871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV 96+ HO... 6914.0 45434.0 4400.0 \n", "291 - HEART FAILURE & SHOCK W MCC 2252.0 14894.0 1273.0 \n", "292 - HEART FAILURE & SHOCK W CC 2092.0 11654.0 1341.0 \n", "392 - ESOPHAGITIS, GASTROENT & MISC DIGEST DISO... 3050.0 12358.0 1728.0 \n", "\n", "Provider State CT DC DE \\\n", "DRG Definition \n", "470 - MAJOR JOINT REPLACEMENT OR REATTACHMENT O... 5689.0 1247.0 2119.0 \n", "871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV 96+ HO... 6390.0 643.0 1556.0 \n", "291 - HEART FAILURE & SHOCK W MCC 2806.0 529.0 1019.0 \n", "292 - HEART FAILURE & SHOCK W CC 2714.0 902.0 936.0 \n", "392 - ESOPHAGITIS, GASTROENT & MISC DIGEST DISO... 2723.0 556.0 782.0 \n", "\n", "Provider State FL ... \\\n", "DRG Definition ... \n", "470 - MAJOR JOINT REPLACEMENT OR REATTACHMENT O... 31086.0 ... \n", "871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV 96+ HO... 25209.0 ... \n", "291 - HEART FAILURE & SHOCK W MCC 14923.0 ... \n", "292 - HEART FAILURE & SHOCK W CC 14274.0 ... \n", "392 - ESOPHAGITIS, GASTROENT & MISC DIGEST DISO... 20322.0 ... \n", "\n", "Provider State TN TX UT \\\n", "DRG Definition \n", "470 - MAJOR JOINT REPLACEMENT OR REATTACHMENT O... 11133.0 29410.0 4455.0 \n", "871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV 96+ HO... 11295.0 30595.0 2780.0 \n", "291 - HEART FAILURE & SHOCK W MCC 5285.0 13718.0 500.0 \n", "292 - HEART FAILURE & SHOCK W CC 4899.0 13047.0 548.0 \n", "392 - ESOPHAGITIS, GASTROENT & MISC DIGEST DISO... 4681.0 12692.0 492.0 \n", "\n", "Provider State VA VT WA \\\n", "DRG Definition \n", "470 - MAJOR JOINT REPLACEMENT OR REATTACHMENT O... 13923.0 766.0 10027.0 \n", "871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV 96+ HO... 15119.0 739.0 10146.0 \n", "291 - HEART FAILURE & SHOCK W MCC 6815.0 303.0 3557.0 \n", "292 - HEART FAILURE & SHOCK W CC 5863.0 318.0 2900.0 \n", "392 - ESOPHAGITIS, GASTROENT & MISC DIGEST DISO... 4884.0 249.0 2435.0 \n", "\n", "Provider State WI WV WY \\\n", "DRG Definition \n", "470 - MAJOR JOINT REPLACEMENT OR REATTACHMENT O... 9482.0 2925.0 651.0 \n", "871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV 96+ HO... 6712.0 3427.0 474.0 \n", "291 - HEART FAILURE & SHOCK W MCC 3028.0 1535.0 161.0 \n", "292 - HEART FAILURE & SHOCK W CC 3175.0 1749.0 212.0 \n", "392 - ESOPHAGITIS, GASTROENT & MISC DIGEST DISO... 2582.0 1632.0 168.0 \n", "\n", "Provider State Total \n", "DRG Definition \n", "470 - MAJOR JOINT REPLACEMENT OR REATTACHMENT O... 458259.0 \n", "871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV 96+ HO... 438597.0 \n", "291 - HEART FAILURE & SHOCK W MCC 198889.0 \n", "292 - HEART FAILURE & SHOCK W CC 192918.0 \n", "392 - ESOPHAGITIS, GASTROENT & MISC DIGEST DISO... 190375.0 \n", "\n", "[5 rows x 52 columns]" ] }, "execution_count": 105, "metadata": {}, "output_type": "execute_result" } ], "source": [ "total_discharges.head()" ] }, { "cell_type": "code", "execution_count": 106, "metadata": {}, "outputs": [], "source": [ "import bqplot" ] }, { "cell_type": "code", "execution_count": 107, "metadata": {}, "outputs": [], "source": [ "import numpy as np" ] }, { "cell_type": "code", "execution_count": 117, "metadata": {}, "outputs": [], "source": [ "total_discharges_norm = total_discharges / total_discharges.sum()" ] }, { "cell_type": "code", "execution_count": 113, "metadata": {}, "outputs": [], "source": [ "bqplot.ColorScale?" ] }, { "cell_type": "code", "execution_count": 122, "metadata": {}, "outputs": [], "source": [ "import bqplot.market_map" ] }, { "cell_type": "code", "execution_count": 132, "metadata": {}, "outputs": [ { "data": { "application/vnd.jupyter.widget-view+json": { "model_id": "ec9255cc1a854cf0b8ff68b405ce89c1", "version_major": 2, "version_minor": 0 }, "text/plain": [ "MarketMap(axes=[ColorAxis(orientation='vertical', scale=ColorScale(scheme='Blues'))], color=array([ 855., 91…" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "x_sc, y_sc = bqplot.OrdinalScale(), bqplot.OrdinalScale()\n", "c_sc = bqplot.ColorScale(scheme = \"Blues\")\n", "total_discharges2 = total_discharges.copy()\n", "del total_discharges2[\"Total\"]\n", "c_ax = bqplot.ColorAxis(scale = c_sc, orientation = 'vertical')\n", "heatmap = bqplot.market_map.MarketMap(color = total_discharges2.iloc[0].values,\n", " names = total_discharges2.columns.values,\n", " scales = {'color': c_sc}, axes = [c_ax])\n", "\n", "heatmap" ] }, { "cell_type": "code", "execution_count": 133, "metadata": {}, "outputs": [], "source": [ "df[\"Total Cost\"] = df[\"Average Total Payments\"] * df[\"Total Discharges\"]" ] }, { "cell_type": "code", "execution_count": 137, "metadata": {}, "outputs": [], "source": [ "total_cost = df.groupby([\"DRG Definition\", \"Provider State\"])[\"Total Cost\"].mean().unstack().fillna(0)" ] }, { "cell_type": "code", "execution_count": 138, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Provider StateAKALARAZCACOCTDCDEFL...SDTNTXUTVAVTWAWIWVWY
DRG Definition
001 - HEART TRANSPLANT OR IMPLANT OF HEART ASSIST SYSTEM W MCC0.03.274392e+060.000000e+004.808456e+068.547044e+060.03845637.56787110.000.04.214039e+06...0.03.382377e+065.439050e+060.04.168565e+060.05424380.03807692.00.000000e+000.0
002 - HEART TRANSPLANT OR IMPLANT OF HEART ASSIST SYSTEM W/O MCC0.00.000000e+000.000000e+000.000000e+000.000000e+000.00.00.000.00.000000e+00...0.00.000000e+000.000000e+000.00.000000e+000.00.00.00.000000e+000.0
003 - ECMO OR TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH & NECK W MAJ O.R.2467452.02.666174e+063.187455e+062.326699e+064.032339e+062886957.54141587.25095057.505310290.53.035271e+06...0.02.600008e+063.396310e+064497993.05.419193e+062274120.02339748.64165996.02.219964e+060.0
004 - TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH & NECK W/O MAJ O.R.1586556.01.169339e+061.370089e+061.262445e+061.580302e+061225651.52229052.02054349.252590256.51.458809e+06...1402297.01.503546e+061.438214e+061287743.01.469648e+060.01166388.01568518.61.142503e+060.0
005 - LIVER TRANSPLANT W MCC OR INTESTINAL TRANSPLANT0.01.100036e+060.000000e+001.504974e+063.791212e+061468419.00.00.000.02.302965e+06...0.01.296045e+061.940034e+060.01.514475e+060.02549264.01908806.00.000000e+000.0
\n", "

5 rows × 51 columns

\n", "
" ], "text/plain": [ "Provider State AK AL \\\n", "DRG Definition \n", "001 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.0 3.274392e+06 \n", "002 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.0 0.000000e+00 \n", "003 - ECMO OR TRACH W MV 96+ HRS OR PDX EXC FAC... 2467452.0 2.666174e+06 \n", "004 - TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH... 1586556.0 1.169339e+06 \n", "005 - LIVER TRANSPLANT W MCC OR INTESTINAL TRAN... 0.0 1.100036e+06 \n", "\n", "Provider State AR \\\n", "DRG Definition \n", "001 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.000000e+00 \n", "002 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.000000e+00 \n", "003 - ECMO OR TRACH W MV 96+ HRS OR PDX EXC FAC... 3.187455e+06 \n", "004 - TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH... 1.370089e+06 \n", "005 - LIVER TRANSPLANT W MCC OR INTESTINAL TRAN... 0.000000e+00 \n", "\n", "Provider State AZ \\\n", "DRG Definition \n", "001 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 4.808456e+06 \n", "002 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.000000e+00 \n", "003 - ECMO OR TRACH W MV 96+ HRS OR PDX EXC FAC... 2.326699e+06 \n", "004 - TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH... 1.262445e+06 \n", "005 - LIVER TRANSPLANT W MCC OR INTESTINAL TRAN... 1.504974e+06 \n", "\n", "Provider State CA CO \\\n", "DRG Definition \n", "001 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 8.547044e+06 0.0 \n", "002 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.000000e+00 0.0 \n", "003 - ECMO OR TRACH W MV 96+ HRS OR PDX EXC FAC... 4.032339e+06 2886957.5 \n", "004 - TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH... 1.580302e+06 1225651.5 \n", "005 - LIVER TRANSPLANT W MCC OR INTESTINAL TRAN... 3.791212e+06 1468419.0 \n", "\n", "Provider State CT DC \\\n", "DRG Definition \n", "001 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 3845637.5 6787110.00 \n", "002 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.0 0.00 \n", "003 - ECMO OR TRACH W MV 96+ HRS OR PDX EXC FAC... 4141587.2 5095057.50 \n", "004 - TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH... 2229052.0 2054349.25 \n", "005 - LIVER TRANSPLANT W MCC OR INTESTINAL TRAN... 0.0 0.00 \n", "\n", "Provider State DE FL \\\n", "DRG Definition \n", "001 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.0 4.214039e+06 \n", "002 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.0 0.000000e+00 \n", "003 - ECMO OR TRACH W MV 96+ HRS OR PDX EXC FAC... 5310290.5 3.035271e+06 \n", "004 - TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH... 2590256.5 1.458809e+06 \n", "005 - LIVER TRANSPLANT W MCC OR INTESTINAL TRAN... 0.0 2.302965e+06 \n", "\n", "Provider State ... SD \\\n", "DRG Definition ... \n", "001 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... ... 0.0 \n", "002 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... ... 0.0 \n", "003 - ECMO OR TRACH W MV 96+ HRS OR PDX EXC FAC... ... 0.0 \n", "004 - TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH... ... 1402297.0 \n", "005 - LIVER TRANSPLANT W MCC OR INTESTINAL TRAN... ... 0.0 \n", "\n", "Provider State TN \\\n", "DRG Definition \n", "001 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 3.382377e+06 \n", "002 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.000000e+00 \n", "003 - ECMO OR TRACH W MV 96+ HRS OR PDX EXC FAC... 2.600008e+06 \n", "004 - TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH... 1.503546e+06 \n", "005 - LIVER TRANSPLANT W MCC OR INTESTINAL TRAN... 1.296045e+06 \n", "\n", "Provider State TX UT \\\n", "DRG Definition \n", "001 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 5.439050e+06 0.0 \n", "002 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.000000e+00 0.0 \n", "003 - ECMO OR TRACH W MV 96+ HRS OR PDX EXC FAC... 3.396310e+06 4497993.0 \n", "004 - TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH... 1.438214e+06 1287743.0 \n", "005 - LIVER TRANSPLANT W MCC OR INTESTINAL TRAN... 1.940034e+06 0.0 \n", "\n", "Provider State VA VT \\\n", "DRG Definition \n", "001 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 4.168565e+06 0.0 \n", "002 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.000000e+00 0.0 \n", "003 - ECMO OR TRACH W MV 96+ HRS OR PDX EXC FAC... 5.419193e+06 2274120.0 \n", "004 - TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH... 1.469648e+06 0.0 \n", "005 - LIVER TRANSPLANT W MCC OR INTESTINAL TRAN... 1.514475e+06 0.0 \n", "\n", "Provider State WA WI \\\n", "DRG Definition \n", "001 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 5424380.0 3807692.0 \n", "002 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.0 0.0 \n", "003 - ECMO OR TRACH W MV 96+ HRS OR PDX EXC FAC... 2339748.6 4165996.0 \n", "004 - TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH... 1166388.0 1568518.6 \n", "005 - LIVER TRANSPLANT W MCC OR INTESTINAL TRAN... 2549264.0 1908806.0 \n", "\n", "Provider State WV WY \n", "DRG Definition \n", "001 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.000000e+00 0.0 \n", "002 - HEART TRANSPLANT OR IMPLANT OF HEART ASSI... 0.000000e+00 0.0 \n", "003 - ECMO OR TRACH W MV 96+ HRS OR PDX EXC FAC... 2.219964e+06 0.0 \n", "004 - TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH... 1.142503e+06 0.0 \n", "005 - LIVER TRANSPLANT W MCC OR INTESTINAL TRAN... 0.000000e+00 0.0 \n", "\n", "[5 rows x 51 columns]" ] }, "execution_count": 138, "metadata": {}, "output_type": "execute_result" } ], "source": [ "total_cost.head()" ] }, { "cell_type": "code", "execution_count": 144, "metadata": {}, "outputs": [ { "data": { "application/vnd.jupyter.widget-view+json": { "model_id": "b7a8e92c648943fdbb611df75eadd9a1", "version_major": 2, "version_minor": 0 }, "text/plain": [ "MarketMap(axes=[ColorAxis(orientation='vertical', scale=ColorScale(scheme='Blues'))], color=array([ 0. …" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "x_sc, y_sc = bqplot.OrdinalScale(), bqplot.OrdinalScale()\n", "c_sc = bqplot.ColorScale(scheme = \"Blues\")\n", "c_ax = bqplot.ColorAxis(scale = c_sc, orientation = 'vertical')\n", "heatmap = bqplot.market_map.MarketMap(color = total_cost.iloc[0].values,\n", " names = total_cost.columns.values,\n", " scales = {'color': c_sc}, axes = [c_ax])\n", "\n", "heatmap" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Environment (conda_is590dv-default)", "language": "python", "name": "conda_is590dv-default" }, "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.6.6" } }, "nbformat": 4, "nbformat_minor": 2 }