Overview

Dataset Statistics

Number of Variables 18
Number of Rows 20607
Missing Cells 213946
Missing Cells (%) 57.7%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 10.2 MB
Average Row Size in Memory 518.7 B
Variable Types
  • Categorical: 5
  • Numerical: 13

Dataset Insights

AETNA and AETNA MEDICARE have similar distributions Similar Distribution
AETNA and BCBS have similar distributions Similar Distribution
AETNA and BCBS MEDICARE have similar distributions Similar Distribution
AETNA and CIGNA have similar distributions Similar Distribution
AETNA and CIGNA MEDICARE have similar distributions Similar Distribution
AETNA and UHC have similar distributions Similar Distribution
AETNA and UHC MEDICARE have similar distributions Similar Distribution
AETNA and HUMANA MEDICARE have similar distributions Similar Distribution
AETNA and MEDCOST have similar distributions Similar Distribution
AETNA and TRICARE have similar distributions Similar Distribution
AETNA MEDICARE and BCBS have similar distributions Similar Distribution
AETNA MEDICARE and BCBS MEDICARE have similar distributions Similar Distribution
AETNA MEDICARE and CIGNA have similar distributions Similar Distribution
AETNA MEDICARE and CIGNA MEDICARE have similar distributions Similar Distribution
AETNA MEDICARE and UHC have similar distributions Similar Distribution
AETNA MEDICARE and UHC MEDICARE have similar distributions Similar Distribution
AETNA MEDICARE and HUMANA MEDICARE have similar distributions Similar Distribution
AETNA MEDICARE and MEDCOST have similar distributions Similar Distribution
AETNA MEDICARE and TRICARE have similar distributions Similar Distribution
BCBS and BCBS MEDICARE have similar distributions Similar Distribution
BCBS and CIGNA have similar distributions Similar Distribution
BCBS and CIGNA MEDICARE have similar distributions Similar Distribution
BCBS and UHC have similar distributions Similar Distribution
BCBS and UHC MEDICARE have similar distributions Similar Distribution
BCBS and HUMANA MEDICARE have similar distributions Similar Distribution
BCBS and MEDCOST have similar distributions Similar Distribution
BCBS and TRICARE have similar distributions Similar Distribution
BCBS MEDICARE and CIGNA have similar distributions Similar Distribution
BCBS MEDICARE and CIGNA MEDICARE have similar distributions Similar Distribution
BCBS MEDICARE and UHC have similar distributions Similar Distribution
BCBS MEDICARE and UHC MEDICARE have similar distributions Similar Distribution
BCBS MEDICARE and HUMANA MEDICARE have similar distributions Similar Distribution
BCBS MEDICARE and MEDCOST have similar distributions Similar Distribution
BCBS MEDICARE and TRICARE have similar distributions Similar Distribution
CIGNA and CIGNA MEDICARE have similar distributions Similar Distribution
CIGNA and UHC have similar distributions Similar Distribution
CIGNA and UHC MEDICARE have similar distributions Similar Distribution
CIGNA and HUMANA MEDICARE have similar distributions Similar Distribution
CIGNA and MEDCOST have similar distributions Similar Distribution
CIGNA and TRICARE have similar distributions Similar Distribution
CIGNA MEDICARE and UHC have similar distributions Similar Distribution
CIGNA MEDICARE and UHC MEDICARE have similar distributions Similar Distribution
CIGNA MEDICARE and HUMANA MEDICARE have similar distributions Similar Distribution
CIGNA MEDICARE and MEDCOST have similar distributions Similar Distribution
CIGNA MEDICARE and TRICARE have similar distributions Similar Distribution
UHC and UHC MEDICARE have similar distributions Similar Distribution
UHC and HUMANA MEDICARE have similar distributions Similar Distribution
UHC and MEDCOST have similar distributions Similar Distribution
UHC and TRICARE have similar distributions Similar Distribution
UHC MEDICARE and HUMANA MEDICARE have similar distributions Similar Distribution
UHC MEDICARE and MEDCOST have similar distributions Similar Distribution
UHC MEDICARE and TRICARE have similar distributions Similar Distribution
HUMANA MEDICARE and MEDCOST have similar distributions Similar Distribution
HUMANA MEDICARE and TRICARE have similar distributions Similar Distribution
MEDCOST and TRICARE have similar distributions Similar Distribution
AETNA has 19567 (94.95%) missing values Missing
AETNA MEDICARE has 19554 (94.89%) missing values Missing
BCBS has 19059 (92.49%) missing values Missing
BCBS MEDICARE has 19550 (94.87%) missing values Missing
CIGNA has 19556 (94.9%) missing values Missing
CIGNA MEDICARE has 19565 (94.94%) missing values Missing
UHC has 18874 (91.59%) missing values Missing
UHC MEDICARE has 19548 (94.86%) missing values Missing
HUMANA MEDICARE has 19550 (94.87%) missing values Missing
MEDCOST has 19560 (94.92%) missing values Missing
TRICARE has 19562 (94.93%) missing values Missing
Gross Charge is skewed Skewed
AETNA is skewed Skewed
AETNA MEDICARE is skewed Skewed
BCBS is skewed Skewed
BCBS MEDICARE is skewed Skewed
CIGNA is skewed Skewed
CIGNA MEDICARE is skewed Skewed
UHC is skewed Skewed
UHC MEDICARE is skewed Skewed
HUMANA MEDICARE is skewed Skewed
MEDCOST is skewed Skewed
TRICARE is skewed Skewed
Self Pay is skewed Skewed
CPT/MS-DRG has a high cardinality: 1425 distinct values High Cardinality
Procedure Description has a high cardinality: 1423 distinct values High Cardinality
Filename has constant value "northern-regional-hospital_standardcharges.csv" Constant
system has constant value "NORTHERN" Constant
Filename has constant length 46 Constant Length
system has constant length 8 Constant Length
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9

Variables

CPT/MS-DRG

categorical

Approximate Distinct Count 1425
Approximate Unique (%) 6.9%
Missing 0
Missing (%) 0.0%
Memory Size 1.4 MB

Length

Mean 4.9999
Standard Deviation 0.01393
Median 5
Minimum 3
Maximum 5

Sample

1st row 00140
2nd row 00140
3rd row 00910
4th row 00910
5th row 00910

Letter

Count 3954
Lowercase Letter 0
Space Separator 0
Uppercase Letter 3954
Dash Punctuation 0
Decimal Number 99079
  • CPT/MS-DRG contains many words: 1425 words

Patient Type

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 1.5 MB

Length

Mean 12.0669
Standard Deviation 1.9989
Median 14
Minimum 10
Maximum 14

Sample

1st row Emergency Room
2nd row Outpatient
3rd row Emergency Room
4th row Outpatient
5th row Outpatient

Letter

Count 238014
Lowercase Letter 206759
Space Separator 10648
Uppercase Letter 31255
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (Emergency Room, Outpatient) take over 50.0%

Procedure Description

categorical

Approximate Distinct Count 1423
Approximate Unique (%) 6.9%
Missing 1
Missing (%) 0.0%
Memory Size 2.4 MB

Length

Mean 58.5909
Standard Deviation 26.1043
Median 52
Minimum 20
Maximum 254

Sample

1st row Anesthesia for pro...
2nd row Anesthesia for pro...
3rd row Anesthesia for pro...
4th row Anesthesia for pro...
5th row Anesthesia for pro...

Letter

Count 874369
Lowercase Letter 773511
Space Separator 158816
Uppercase Letter 100858
Dash Punctuation 3208
Decimal Number 106814
  • Procedure Description contains many words: 3283 words
  • The largest value (cpt) is over 3.74 times larger than the second largest value (blood)

Gross Charge

numerical

Approximate Distinct Count 8496
Approximate Unique (%) 41.2%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 322.0 KB
Mean 3224.323
Minimum 0.01
Maximum 57697
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Gross Charge is skewed right (γ1 = 2.7127)

Quantile Statistics

Minimum 0.01
5-th Percentile 81
Q1 554
Median 1768.91
Q3 4380
95-th Percentile 11224.79
Maximum 57697
Range 57696.99
IQR 3826

Descriptive Statistics

Mean 3224.323
Standard Deviation 3913.8218
Variance 1.5318e+07
Sum 6.6444e+07
Skewness 2.7127
Kurtosis 14.3023
Coefficient of Variation 1.2138
  • Gross Charge is not normally distributed (p-value 7.44498604339587e-20)
  • Gross Charge has 1326 outliers

AETNA

numerical

Approximate Distinct Count 622
Approximate Unique (%) 59.8%
Missing 19567
Missing (%) 95.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 16.2 KB
Mean 377.8745
Minimum 0.007459
Maximum 17425.2239
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • AETNA is skewed right (γ1 = 9.169)

Quantile Statistics

Minimum 0.007459
5-th Percentile 9.1333
Q1 35.0593
Median 78.697
Q3 272.6421
95-th Percentile 1675.1693
Maximum 17425.2239
Range 17425.2164
IQR 237.5828

Descriptive Statistics

Mean 377.8745
Standard Deviation 1130.1957
Variance 1.2773e+06
Sum 392989.5184
Skewness 9.169
Kurtosis 108.2111
Coefficient of Variation 2.9909
  • AETNA is not normally distributed (p-value 8.743217209940861e-25)
  • AETNA has 149 outliers

AETNA MEDICARE

numerical

Approximate Distinct Count 663
Approximate Unique (%) 63.0%
Missing 19554
Missing (%) 94.9%
Infinite 0
Infinite (%) 0.0%
Memory Size 16.5 KB
Mean 2492.6844
Minimum 0.007459
Maximum 32980.06
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • AETNA MEDICARE is skewed right (γ1 = 2.4151)

Quantile Statistics

Minimum 0.007459
5-th Percentile 14.3221
Q1 46.9944
Median 205.8802
Q3 2108.38
95-th Percentile 13251.404
Maximum 32980.06
Range 32980.0525
IQR 2061.3856

Descriptive Statistics

Mean 2492.6844
Standard Deviation 4693.1516
Variance 2.2026e+07
Sum 2.6248e+06
Skewness 2.4151
Kurtosis 5.8899
Coefficient of Variation 1.8828
  • AETNA MEDICARE is not normally distributed (p-value 1.3396231954134547e-24)
  • AETNA MEDICARE has 181 outliers

BCBS

numerical

Approximate Distinct Count 621
Approximate Unique (%) 40.1%
Missing 19059
Missing (%) 92.5%
Infinite 0
Infinite (%) 0.0%
Memory Size 24.2 KB
Mean 335.1788
Minimum 0.007459
Maximum 17425.2239
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • BCBS is skewed right (γ1 = 11.3448)

Quantile Statistics

Minimum 0.007459
5-th Percentile 8.7648
Q1 34.4045
Median 74.9262
Q3 253.6206
95-th Percentile 1609.7484
Maximum 17425.2239
Range 17425.2164
IQR 219.216

Descriptive Statistics

Mean 335.1788
Standard Deviation 980.7751
Variance 961919.8788
Sum 518856.767
Skewness 11.3448
Kurtosis 174.5959
Coefficient of Variation 2.9261
  • BCBS is not normally distributed (p-value 7.996857125134202e-25)
  • BCBS has 220 outliers

BCBS MEDICARE

numerical

Approximate Distinct Count 684
Approximate Unique (%) 64.7%
Missing 19550
Missing (%) 94.9%
Infinite 0
Infinite (%) 0.0%
Memory Size 16.5 KB
Mean 2916.7763
Minimum 0.007459
Maximum 32980.06
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • BCBS MEDICARE is skewed right (γ1 = 2.2657)

Quantile Statistics

Minimum 0.007459
5-th Percentile 15.1874
Q1 58.9295
Median 380.4308
Q3 3711.88
95-th Percentile 14124.17
Maximum 32980.06
Range 32980.0525
IQR 3652.9505

Descriptive Statistics

Mean 2916.7763
Standard Deviation 4894.5445
Variance 2.3957e+07
Sum 3.083e+06
Skewness 2.2657
Kurtosis 5.5521
Coefficient of Variation 1.6781
  • BCBS MEDICARE is not normally distributed (p-value 3.950973273168271e-24)
  • BCBS MEDICARE has 126 outliers

CIGNA

numerical

Approximate Distinct Count 676
Approximate Unique (%) 64.3%
Missing 19556
Missing (%) 94.9%
Infinite 0
Infinite (%) 0.0%
Memory Size 16.4 KB
Mean 2505.9118
Minimum 0.007459
Maximum 32980.06
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • CIGNA is skewed right (γ1 = 2.438)

Quantile Statistics

Minimum 0.007459
5-th Percentile 14.5981
Q1 55.9233
Median 287.188
Q3 2387.195
95-th Percentile 13007.35
Maximum 32980.06
Range 32980.0525
IQR 2331.2717

Descriptive Statistics

Mean 2505.9118
Standard Deviation 4544.526
Variance 2.0653e+07
Sum 2.6337e+06
Skewness 2.438
Kurtosis 6.2465
Coefficient of Variation 1.8135
  • CIGNA is not normally distributed (p-value 2.2175521194055655e-24)
  • CIGNA has 165 outliers

CIGNA MEDICARE

numerical

Approximate Distinct Count 627
Approximate Unique (%) 60.2%
Missing 19565
Missing (%) 94.9%
Infinite 0
Infinite (%) 0.0%
Memory Size 16.3 KB
Mean 726.9979
Minimum 0.007459
Maximum 17425.2239
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • CIGNA MEDICARE is skewed right (γ1 = 5.3354)

Quantile Statistics

Minimum 0.007459
5-th Percentile 10.344
Q1 36.4412
Median 87.1373
Q3 312.8867
95-th Percentile 2381.2818
Maximum 17425.2239
Range 17425.2164
IQR 276.4455

Descriptive Statistics

Mean 726.9979
Standard Deviation 2325.3735
Variance 5.4074e+06
Sum 757531.8496
Skewness 5.3354
Kurtosis 30.1854
Coefficient of Variation 3.1986
  • CIGNA MEDICARE is not normally distributed (p-value 9.007783883190298e-25)
  • CIGNA MEDICARE has 169 outliers

UHC

numerical

Approximate Distinct Count 830
Approximate Unique (%) 47.9%
Missing 18874
Missing (%) 91.6%
Infinite 0
Infinite (%) 0.0%
Memory Size 27.1 KB
Mean 1757.02
Minimum 0.007459
Maximum 32980.06
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • UHC is skewed right (γ1 = 3.454)

Quantile Statistics

Minimum 0.007459
5-th Percentile 12.8959
Q1 44.0106
Median 148.4426
Q3 1100.2656
95-th Percentile 10370.49
Maximum 32980.06
Range 32980.0525
IQR 1056.255

Descriptive Statistics

Mean 1757.02
Standard Deviation 4033.2835
Variance 1.6267e+07
Sum 3.0449e+06
Skewness 3.454
Kurtosis 13.7517
Coefficient of Variation 2.2955
  • UHC is not normally distributed (p-value 1.2661420446487184e-24)
  • UHC has 268 outliers

UHC MEDICARE

numerical

Approximate Distinct Count 690
Approximate Unique (%) 65.2%
Missing 19548
Missing (%) 94.9%
Infinite 0
Infinite (%) 0.0%
Memory Size 16.5 KB
Mean 3019.8684
Minimum 0.007459
Maximum 32980.06
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • UHC MEDICARE is skewed right (γ1 = 2.2216)

Quantile Statistics

Minimum 0.007459
5-th Percentile 16.4107
Q1 64.897
Median 550.99
Q3 4004.68
95-th Percentile 13599.29
Maximum 32980.06
Range 32980.0525
IQR 3939.783

Descriptive Statistics

Mean 3019.8684
Standard Deviation 4866.3625
Variance 2.3681e+07
Sum 3.198e+06
Skewness 2.2216
Kurtosis 5.4466
Coefficient of Variation 1.6114
  • UHC MEDICARE is not normally distributed (p-value 5.506231855497707e-24)
  • UHC MEDICARE has 105 outliers

HUMANA MEDICARE

numerical

Approximate Distinct Count 686
Approximate Unique (%) 64.9%
Missing 19550
Missing (%) 94.9%
Infinite 0
Infinite (%) 0.0%
Memory Size 16.5 KB
Mean 2893.0294
Minimum 0.007459
Maximum 32980.06
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • HUMANA MEDICARE is skewed right (γ1 = 2.2564)

Quantile Statistics

Minimum 0.007459
5-th Percentile 14.9189
Q1 55.9457
Median 352.085
Q3 3896.38
95-th Percentile 13540.97
Maximum 32980.06
Range 32980.0525
IQR 3840.4343

Descriptive Statistics

Mean 2893.0294
Standard Deviation 4864.2582
Variance 2.3661e+07
Sum 3.0579e+06
Skewness 2.2564
Kurtosis 5.5805
Coefficient of Variation 1.6814
  • HUMANA MEDICARE is not normally distributed (p-value 2.1862812545362456e-24)
  • HUMANA MEDICARE has 114 outliers

MEDCOST

numerical

Approximate Distinct Count 647
Approximate Unique (%) 61.8%
Missing 19560
Missing (%) 94.9%
Infinite 0
Infinite (%) 0.0%
Memory Size 16.4 KB
Mean 1941.2307
Minimum 0.007459
Maximum 32980.06
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • MEDCOST is skewed right (γ1 = 3.0682)

Quantile Statistics

Minimum 0.007459
5-th Percentile 12.681
Q1 44.7566
Median 151.0236
Q3 1117.9371
95-th Percentile 12992.848
Maximum 32980.06
Range 32980.0525
IQR 1073.1805

Descriptive Statistics

Mean 1941.2307
Standard Deviation 4387.9731
Variance 1.9254e+07
Sum 2.0325e+06
Skewness 3.0682
Kurtosis 9.6664
Coefficient of Variation 2.2604
  • MEDCOST is not normally distributed (p-value 1.1755365268520016e-24)
  • MEDCOST has 166 outliers

TRICARE

numerical

Approximate Distinct Count 644
Approximate Unique (%) 61.6%
Missing 19562
Missing (%) 94.9%
Infinite 0
Infinite (%) 0.0%
Memory Size 16.3 KB
Mean 1489.1712
Minimum 0.007459
Maximum 21133.46
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • TRICARE is skewed right (γ1 = 3.2425)

Quantile Statistics

Minimum 0.007459
5-th Percentile 11.6367
Q1 41.0269
Median 116.3671
Q3 675.31
95-th Percentile 10001.176
Maximum 21133.46
Range 21133.4525
IQR 634.2831

Descriptive Statistics

Mean 1489.1712
Standard Deviation 3631.5521
Variance 1.3188e+07
Sum 1.5562e+06
Skewness 3.2425
Kurtosis 10.3888
Coefficient of Variation 2.4386
  • TRICARE is not normally distributed (p-value 7.652988588151871e-25)
  • TRICARE has 177 outliers

Self Pay

numerical

Approximate Distinct Count 8490
Approximate Unique (%) 41.2%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 322.0 KB
Mean 2192.5396
Minimum 0.0068
Maximum 39233.96
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Self Pay is skewed right (γ1 = 2.7127)

Quantile Statistics

Minimum 0.0068
5-th Percentile 55.08
Q1 376.72
Median 1202.8588
Q3 2978.4
95-th Percentile 7632.8572
Maximum 39233.96
Range 39233.9532
IQR 2601.68

Descriptive Statistics

Mean 2192.5396
Standard Deviation 2661.3988
Variance 7.083e+06
Sum 4.5182e+07
Skewness 2.7127
Kurtosis 14.3023
Coefficient of Variation 1.2138
  • Self Pay is not normally distributed (p-value 7.44498604339587e-20)
  • Self Pay has 1326 outliers

Filename

categorical

Approximate Distinct Count 1
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 2.2 MB

Length

Mean 46
Standard Deviation 0
Median 46
Minimum 46
Maximum 46

Sample

1st row northern-regional-...
2nd row northern-regional-...
3rd row northern-regional-...
4th row northern-regional-...
5th row northern-regional-...

Letter

Count 865494
Lowercase Letter 865494
Space Separator 0
Uppercase Letter 0
Dash Punctuation 41214
Decimal Number 0
  • Filename has words of constant length

system

categorical

Approximate Distinct Count 1
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 1.4 MB

Length

Mean 8
Standard Deviation 0
Median 8
Minimum 8
Maximum 8

Sample

1st row NORTHERN
2nd row NORTHERN
3rd row NORTHERN
4th row NORTHERN
5th row NORTHERN

Letter

Count 164856
Lowercase Letter 0
Space Separator 0
Uppercase Letter 164856
Dash Punctuation 0
Decimal Number 0
  • system has words of constant length

Interactions

Correlations

Missing Values