Medical charge

Show:

Click on a table cell below to display more information about its column.

DRG_Definition	Provider_Id	Provider_Name	Provider_Street_Address	Provider_City	Provider_State	Provider_Zip_Code	Hospital_Referral_Region_(HRR)_Description	Total_Discharges	Average_Covered_Charges	Average_Medicare_Payments
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10001	SOUTHEAST ALABAMA MEDICAL CENTER	1108 ROSS CLARK CIRCLE	DOTHAN	AL	36301	AL - Dothan	91	32963.07692	4763.736264
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	AL - Birmingham	14	15131.85714	4976.714286
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10006	ELIZA COFFEE MEMORIAL HOSPITAL	205 MARENGO STREET	FLORENCE	AL	35631	AL - Birmingham	24	37560.375	4453.791667
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10011	ST VINCENT'S EAST	50 MEDICAL PARK EAST DRIVE	BIRMINGHAM	AL	35235	AL - Birmingham	25	13998.28	4129.16
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10016	SHELBY BAPTIST MEDICAL CENTER	1000 FIRST STREET NORTH	ALABASTER	AL	35007	AL - Birmingham	18	31633.27778	4851.444444
⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮
948 - SIGNS & SYMPTOMS W/O MCC	670041	SETON MEDICAL CENTER WILLIAMSON	201 SETON PARKWAY	ROUND ROCK	TX	78664	TX - Austin	23	26314.3913	3071.391304
948 - SIGNS & SYMPTOMS W/O MCC	670055	METHODIST STONE OAK HOSPITAL	1139 E SONTERRA BLVD	SAN ANTONIO	TX	78258	TX - San Antonio	11	21704.72727	2649.727273
948 - SIGNS & SYMPTOMS W/O MCC	670056	SETON MEDICAL CENTER HAYS	6001 KYLE PKWY	KYLE	TX	78640	TX - Austin	19	39121.73684	4058.368421
948 - SIGNS & SYMPTOMS W/O MCC	670060	TEXAS REGIONAL MEDICAL CENTER AT SUNNYVALE	231 SOUTH COLLINS ROAD	SUNNYVALE	TX	75182	TX - Dallas	11	28873.090910000003	6848.545455
948 - SIGNS & SYMPTOMS W/O MCC	670068	TEXAS HEALTH PRESBYTERIAN HOSPITAL FLOWER MOUND	4400 LONG PRAIRIE ROAD	FLOWER MOUND	TX	75028	TX - Dallas	12	15042.0	2887.416667

163065 rows ✕ 11 columns.

`DRG_Definition`

ObjectDType

Null values: 0 (0.0%)
Unique values: 100 (< 0.1%)

Most frequent values

194 - SIMPLE PNEUMONIA & PLEURISY W CC

690 - KIDNEY & URINARY TRACT INFECTIONS W/O MCC

292 - HEART FAILURE & SHOCK W CC

392 - ESOPHAGITIS, GASTROENT & MISC DIGEST DISORDERS W/O MCC

641 - MISC DISORDERS OF NUTRITION,METABOLISM,FLUIDS/ELECTROLYTES W/O MCC

871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV 96+ HOURS W MCC

603 - CELLULITIS W/O MCC

470 - MAJOR JOINT REPLACEMENT OR REATTACHMENT OF LOWER EXTREMITY W/O MCC

191 - CHRONIC OBSTRUCTIVE PULMONARY DISEASE W CC

190 - CHRONIC OBSTRUCTIVE PULMONARY DISEASE W MCC

List:

['194 - SIMPLE PNEUMONIA & PLEURISY W CC', '690 - KIDNEY & URINARY TRACT INFECTIONS W/O MCC', '292 - HEART FAILURE & SHOCK W CC', '392 - ESOPHAGITIS, GASTROENT & MISC DIGEST DISORDERS W/O MCC', '641 - MISC DISORDERS OF NUTRITION,METABOLISM,FLUIDS/ELECTROLYTES W/O MCC', '871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV 96+ HOURS W MCC', '603 - CELLULITIS W/O MCC', '470 - MAJOR JOINT REPLACEMENT OR REATTACHMENT OF LOWER EXTREMITY W/O MCC', '191 - CHRONIC OBSTRUCTIVE PULMONARY DISEASE W CC', '190 - CHRONIC OBSTRUCTIVE PULMONARY DISEASE W MCC']

`Provider_Id`

Int64DType

Null values: 0 (0.0%)
Mean ± Std: 2.56e+05 ± 1.52e+05
Median ± IQR: 250007 ± 269983
Min ; Max: 10001 ; 670077

`Provider_Name`

ObjectDType

Null values: 0 (0.0%)
Unique values: 3201 (2.0%)

Most frequent values

GOOD SAMARITAN HOSPITAL

ST JOSEPH MEDICAL CENTER

MERCY MEDICAL CENTER

MERCY HOSPITAL

ST JOSEPH HOSPITAL

ST FRANCIS MEDICAL CENTER

ST MARY MEDICAL CENTER

ST LUKES HOSPITAL

ST FRANCIS HOSPITAL

JEFFERSON REGIONAL MEDICAL CENTER

List:

['GOOD SAMARITAN HOSPITAL', 'ST JOSEPH MEDICAL CENTER', 'MERCY MEDICAL CENTER', 'MERCY HOSPITAL', 'ST JOSEPH HOSPITAL', 'ST FRANCIS MEDICAL CENTER', 'ST MARY MEDICAL CENTER', 'ST LUKES HOSPITAL', 'ST FRANCIS HOSPITAL', 'JEFFERSON REGIONAL MEDICAL CENTER']

`Provider_Street_Address`

ObjectDType

Null values: 0 (0.0%)
Unique values: 3326 (2.0%)

Most frequent values

100 MEDICAL CENTER DRIVE

800 WASHINGTON STREET

1 MEDICAL CENTER DRIVE

100 HOSPITAL DRIVE

110 IRVING ST NW

9601 INTERSTATE 630, EXIT 7

55 LAKE AVENUE NORTH

18101 OAKWOOD BLVD

330 BROOKLINE AVENUE

55 FRUIT STREET

List:

['100 MEDICAL CENTER DRIVE', '800 WASHINGTON STREET', '1 MEDICAL CENTER DRIVE', '100 HOSPITAL DRIVE', '110 IRVING ST NW', '9601 INTERSTATE 630, EXIT 7', '55 LAKE AVENUE NORTH', '18101 OAKWOOD BLVD', '330 BROOKLINE AVENUE', '55 FRUIT STREET']

`Provider_City`

ObjectDType

Null values: 0 (0.0%)
Unique values: 1977 (1.2%)

Most frequent values

CHICAGO

BALTIMORE

HOUSTON

PHILADELPHIA

BROOKLYN

SPRINGFIELD

COLUMBUS

LOS ANGELES

NEW YORK

DALLAS

List:

['CHICAGO', 'BALTIMORE', 'HOUSTON', 'PHILADELPHIA', 'BROOKLYN', 'SPRINGFIELD', 'COLUMBUS', 'LOS ANGELES', 'NEW YORK', 'DALLAS']

`Provider_State`

ObjectDType

Null values: 0 (0.0%)
Unique values: 51 (< 0.1%)

Most frequent values

CA

TX

FL

NY

IL

PA

OH

MI

NC

GA

List:

['CA', 'TX', 'FL', 'NY', 'IL', 'PA', 'OH', 'MI', 'NC', 'GA']

`Provider_Zip_Code`

Int64DType

Null values: 0 (0.0%)
Mean ± Std: 4.79e+04 ± 2.79e+04
Median ± IQR: 44309 ± 45640
Min ; Max: 1040 ; 99835

`Hospital_Referral_Region_(HRR)_Description`

ObjectDType

Null values: 0 (0.0%)
Unique values: 306 (0.2%)

Most frequent values

CA - Los Angeles

MA - Boston

GA - Atlanta

TX - Houston

PA - Philadelphia

TX - Dallas

MO - St. Louis

NY - East Long Island

FL - Orlando

TN - Nashville

List:

['CA - Los Angeles', 'MA - Boston', 'GA - Atlanta', 'TX - Houston', 'PA - Philadelphia', 'TX - Dallas', 'MO - St. Louis', 'NY - East Long Island', 'FL - Orlando', 'TN - Nashville']

`Total_Discharges`

Int64DType

Null values: 0 (0.0%)
Mean ± Std: 42.8 ± 51.1
Median ± IQR: 27 ± 32
Min ; Max: 11 ; 3383

`Average_Covered_Charges`

Float64DType

Null values: 0 (0.0%)
Mean ± Std: 3.61e+04 ± 3.51e+04
Median ± IQR: 2.52e+04 ± 2.73e+04
Min ; Max: 2.46e+03 ; 9.29e+05

`Average_Medicare_Payments`

Float64DType

Null values: 0 (0.0%)
Mean ± Std: 8.49e+03 ± 7.31e+03
Median ± IQR: 6.16e+03 ± 5.86e+03
Min ; Max: 1.15e+03 ; 1.55e+05

No columns match the selected filter: . You can change the column filter in the dropdown menu above.

The table below shows the strength of association between the most similar columns in the dataframe. Cramér's V statistic is a number between 0 and 1. When it is close to 1 the columns are strongly associated — they contain similar information. In this case, one of them may be redundant and for some models (such as linear models) it might be beneficial to remove it.

Column 1	Column 2	Cramér's V
Provider_State	Provider_Zip_Code	0.601
Provider_Id	Provider_State	0.565
Provider_City	Hospital_Referral_Region_(HRR)_Description	0.435
Average_Covered_Charges	Average_Medicare_Payments	0.419
Provider_Id	Provider_Zip_Code	0.397
Provider_State	Hospital_Referral_Region_(HRR)_Description	0.389
Provider_Zip_Code	Hospital_Referral_Region_(HRR)_Description	0.376
Provider_Id	Hospital_Referral_Region_(HRR)_Description	0.325
Provider_Name	Provider_Street_Address	0.309
Provider_City	Provider_State	0.287
Provider_City	Provider_Zip_Code	0.233