Overview

Dataset Statistics

Number of Variables 20
Number of Rows 761
Missing Cells 0
Missing Cells (%) 0.0%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 1.8 MB
Average Row Size in Memory 2.4 KB
Variable Types
  • Numerical: 1
  • Categorical: 19

Dataset Insights

MS DRG w Description has a high cardinality: 761 distinct values High Cardinality
Medicare Adv - Aetna has a high cardinality: 337 distinct values High Cardinality
Medicare Adv - BCBS has a high cardinality: 276 distinct values High Cardinality
Medicare Adv - Humana has a high cardinality: 375 distinct values High Cardinality
Medicare Adv - United has a high cardinality: 453 distinct values High Cardinality
Medicare Adv - Other has a high cardinality: 203 distinct values High Cardinality
Aetna has a high cardinality: 334 distinct values High Cardinality
BCBS has a high cardinality: 577 distinct values High Cardinality
Cigna has a high cardinality: 325 distinct values High Cardinality
Exchange/Ambetter has a high cardinality: 108 distinct values High Cardinality
Medcost has a high cardinality: 111 distinct values High Cardinality
United has a high cardinality: 356 distinct values High Cardinality
Other Mgd Care has a high cardinality: 200 distinct values High Cardinality
Tricare has a high cardinality: 342 distinct values High Cardinality
Self Pay has a high cardinality: 722 distinct values High Cardinality
De-identified Minimum has a high cardinality: 566 distinct values High Cardinality
De-identified Maximum has a high cardinality: 680 distinct values High Cardinality
Filename has constant value "56-2070036_DUH_standardcharges_drg.csv" Constant
Filename has constant length 38 Constant Length
MS DRG w Description has all distinct values Unique
  • 1
  • 2

Variables

MS DRG

numerical

Approximate Distinct Count 761
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 11.9 KB
Mean 480.5926
Minimum 1
Maximum 999
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • MS DRG is skewed right (γ1 = 0.0506)

Quantile Statistics

Minimum 1
5-th Percentile 52
Q1 243
Median 475
Q3 725
95-th Percentile 923
Maximum 999
Range 998
IQR 482

Descriptive Statistics

Mean 480.5926
Standard Deviation 281.5197
Variance 79253.3628
Sum 365731
Skewness 0.05058
Kurtosis -1.1732
Coefficient of Variation 0.5858

MS DRG w Description

categorical

Approximate Distinct Count 761
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Memory Size 90.9 KB

Length

Mean 57.3482
Standard Deviation 21.0244
Median 54
Minimum 15
Maximum 148

Sample

1st row 1 - HEART TRANSPLA...
2nd row 2 - HEART TRANSPLA...
3rd row 3 - ECMO OR TRACHE...
4th row 4 - TRACHEOSTOMY W...
5th row 5 - LIVER TRANSPLA...

Letter

Count 33828
Lowercase Letter 0
Space Separator 6192
Uppercase Letter 33828
Dash Punctuation 798
Decimal Number 2217
  • MS DRG w Description contains many words: 1270 words
  • The largest value (with) is over 1.66 times larger than the second largest value (without)

Medicare Adv - Aetna

categorical

Approximate Distinct Count 337
Approximate Unique (%) 44.3%
Missing 0
Missing (%) 0.0%
Memory Size 110.2 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 425.0 times larger than the second largest value (Average payment of 1,283.87, with a minimum and maximum of 1,283.87 and 1,283.87, respectively)

Length

Mean 83.2576
Standard Deviation 11.5775
Median 73
Minimum 73
Maximum 100

Sample

1st row Average payment of...
2nd row Average payment of...
3rd row Average payment of...
4th row Average payment of...
5th row Average payment of...

Letter

Count 43980
Lowercase Letter 41944
Space Separator 9893
Uppercase Letter 2036
Dash Punctuation 0
Decimal Number 6798
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,283.87, with a minimum and maximum of 1,283.87 and 1,283.87, respectively) take over 50.0%
  • The largest value (payment) is over 1.79 times larger than the second largest value (data)

Medicare Adv - BCBS

categorical

Approximate Distinct Count 276
Approximate Unique (%) 36.3%
Missing 0
Missing (%) 0.0%
Memory Size 108.8 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 486.0 times larger than the second largest value (Average payment of 1,936.55, with a minimum and maximum of 1,936.55 and 1,936.55, respectively)

Length

Mean 81.4008
Standard Deviation 11.2064
Median 73
Minimum 73
Maximum 100

Sample

1st row Average payment of...
2nd row Payment data is no...
3rd row Average payment of...
4th row Payment data is no...
5th row Average payment of...

Letter

Count 44285
Lowercase Letter 42066
Space Separator 9893
Uppercase Letter 2219
Dash Punctuation 0
Decimal Number 5568
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,936.55, with a minimum and maximum of 1,936.55 and 1,936.55, respectively) take over 50.0%
  • The largest value (payment) is over 1.57 times larger than the second largest value (data)

Medicare Adv - Humana

categorical

Approximate Distinct Count 375
Approximate Unique (%) 49.3%
Missing 0
Missing (%) 0.0%
Memory Size 111.0 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 387.0 times larger than the second largest value (Average payment of 1,064.08, with a minimum and maximum of 1,064.08 and 1,064.08, respectively)

Length

Mean 84.3101
Standard Deviation 11.5702
Median 73
Minimum 73
Maximum 100

Sample

1st row Average payment of...
2nd row Average payment of...
3rd row Average payment of...
4th row Average payment of...
5th row Average payment of...

Letter

Count 43790
Lowercase Letter 41868
Space Separator 9893
Uppercase Letter 1922
Dash Punctuation 0
Decimal Number 7499
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,064.08, with a minimum and maximum of 1,064.08 and 1,064.08, respectively) take over 50.0%
  • The largest value (payment) is over 1.97 times larger than the second largest value (available)

Medicare Adv - United

categorical

Approximate Distinct Count 453
Approximate Unique (%) 59.5%
Missing 0
Missing (%) 0.0%
Memory Size 112.8 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 309.0 times larger than the second largest value (Average payment of 10,006.95, with a minimum and maximum of 9,403.68 and 10,610.22, respectively)

Length

Mean 86.7989
Standard Deviation 11.4593
Median 94
Minimum 73
Maximum 100

Sample

1st row Average payment of...
2nd row Payment data is no...
3rd row Average payment of...
4th row Average payment of...
5th row Average payment of...

Letter

Count 43400
Lowercase Letter 41712
Space Separator 9893
Uppercase Letter 1688
Dash Punctuation 0
Decimal Number 9147
  • Medicare Adv - United contains many words: 1076 words
  • The largest value (payment) is over 1.68 times larger than the second largest value (maximum)

Medicare Adv - Other

categorical

Approximate Distinct Count 203
Approximate Unique (%) 26.7%
Missing 0
Missing (%) 0.0%
Memory Size 107.1 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 559.0 times larger than the second largest value (Average payment of 1,182.00, with a minimum and maximum of 1,182.00 and 1,182.00, respectively)

Length

Mean 79.1419
Standard Deviation 10.253
Median 73
Minimum 73
Maximum 100

Sample

1st row Average payment of...
2nd row Average payment of...
3rd row Average payment of...
4th row Average payment of...
5th row Payment data is no...

Letter

Count 44650
Lowercase Letter 42212
Space Separator 9893
Uppercase Letter 2438
Dash Punctuation 0
Decimal Number 4073
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,182.00, with a minimum and maximum of 1,182.00 and 1,182.00, respectively) take over 50.0%

Aetna

categorical

Approximate Distinct Count 334
Approximate Unique (%) 43.9%
Missing 0
Missing (%) 0.0%
Memory Size 111.3 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 16.18 times larger than the second largest value (Average payment of 5,358.00, with a minimum and maximum of 5,358.00 and 5,358.00, respectively)

Length

Mean 84.7924
Standard Deviation 11.1472
Median 94
Minimum 73
Maximum 102

Sample

1st row Average payment of...
2nd row Average payment of...
3rd row Average payment of...
4th row Payment data is no...
5th row Average payment of...

Letter

Count 43635
Lowercase Letter 41806
Space Separator 9893
Uppercase Letter 1829
Dash Punctuation 0
Decimal Number 7787
  • The largest value (payment) is over 1.88 times larger than the second largest value (average)

BCBS

categorical

Approximate Distinct Count 577
Approximate Unique (%) 75.8%
Missing 0
Missing (%) 0.0%
Memory Size 115.9 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 185.0 times larger than the second largest value (Average payment of 1,897.25, with a minimum and maximum of 200.00 and 2,980.77, respectively)

Length

Mean 90.9409
Standard Deviation 10.2599
Median 97
Minimum 73
Maximum 101

Sample

1st row Average payment of...
2nd row Average payment of...
3rd row Average payment of...
4th row Average payment of...
5th row Average payment of...

Letter

Count 42780
Lowercase Letter 41464
Space Separator 9893
Uppercase Letter 1316
Dash Punctuation 0
Decimal Number 11934
  • BCBS contains many words: 1505 words

Cigna

categorical

Approximate Distinct Count 325
Approximate Unique (%) 42.7%
Missing 0
Missing (%) 0.0%
Memory Size 110.4 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 60.86 times larger than the second largest value (Average payment of 13,731.00, with a minimum and maximum of 13,731.00 and 13,731.00, respectively)

Length

Mean 83.4888
Standard Deviation 11.8814
Median 73
Minimum 73
Maximum 102

Sample

1st row Average payment of...
2nd row Payment data is no...
3rd row Average payment of...
4th row Average payment of...
5th row Average payment of...

Letter

Count 43985
Lowercase Letter 41946
Space Separator 9893
Uppercase Letter 2039
Dash Punctuation 0
Decimal Number 6988
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 13,731.00, with a minimum and maximum of 13,731.00 and 13,731.00, respectively) take over 50.0%
  • The largest value (payment) is over 1.79 times larger than the second largest value (available)

Exchange/Ambetter

categorical

Approximate Distinct Count 108
Approximate Unique (%) 14.2%
Missing 0
Missing (%) 0.0%
Memory Size 105.1 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 654.0 times larger than the second largest value (Average payment of 1,961.16, with a minimum and maximum of 1,469.04 and 4,277.58, respectively)

Length

Mean 76.3693
Standard Deviation 8.3431
Median 73
Minimum 73
Maximum 100

Sample

1st row Payment data is no...
2nd row Payment data is no...
3rd row Payment data is no...
4th row Average payment of...
5th row Average payment of...

Letter

Count 45125
Lowercase Letter 42402
Space Separator 9893
Uppercase Letter 2723
Dash Punctuation 0
Decimal Number 2243
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,961.16, with a minimum and maximum of 1,469.04 and 4,277.58, respectively) take over 50.0%

Medcost

categorical

Approximate Distinct Count 111
Approximate Unique (%) 14.6%
Missing 0
Missing (%) 0.0%
Memory Size 105.1 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 651.0 times larger than the second largest value (Average payment of 1,790.36, with a minimum and maximum of 39.90 and 3,921.45, respectively)

Length

Mean 76.3693
Standard Deviation 8.2327
Median 73
Minimum 73
Maximum 100

Sample

1st row Payment data is no...
2nd row Payment data is no...
3rd row Average payment of...
4th row Payment data is no...
5th row Payment data is no...

Letter

Count 45110
Lowercase Letter 42396
Space Separator 9893
Uppercase Letter 2714
Dash Punctuation 0
Decimal Number 2240
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,790.36, with a minimum and maximum of 39.90 and 3,921.45, respectively) take over 50.0%

United

categorical

Approximate Distinct Count 356
Approximate Unique (%) 46.8%
Missing 0
Missing (%) 0.0%
Memory Size 111.0 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 34.73 times larger than the second largest value (Average payment of 7,315.00, with a minimum and maximum of 7,315.00 and 7,315.00, respectively)

Length

Mean 84.3561
Standard Deviation 11.4936
Median 73
Minimum 73
Maximum 102

Sample

1st row Average payment of...
2nd row Payment data is no...
3rd row Average payment of...
4th row Average payment of...
5th row Average payment of...

Letter

Count 43765
Lowercase Letter 41858
Space Separator 9893
Uppercase Letter 1907
Dash Punctuation 0
Decimal Number 7520
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 7,315.00, with a minimum and maximum of 7,315.00 and 7,315.00, respectively) take over 50.0%
  • The largest value (payment) is over 1.99 times larger than the second largest value (data)

Other Mgd Care

categorical

Approximate Distinct Count 200
Approximate Unique (%) 26.3%
Missing 0
Missing (%) 0.0%
Memory Size 107.2 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 562.0 times larger than the second largest value (Average payment of 1,208.21, with a minimum and maximum of 664.00 and 3,233.53, respectively)

Length

Mean 79.2273
Standard Deviation 10.5096
Median 73
Minimum 73
Maximum 100

Sample

1st row Average payment of...
2nd row Payment data is no...
3rd row Average payment of...
4th row Average payment of...
5th row Average payment of...

Letter

Count 44665
Lowercase Letter 42218
Space Separator 9893
Uppercase Letter 2447
Dash Punctuation 0
Decimal Number 4151
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,208.21, with a minimum and maximum of 664.00 and 3,233.53, respectively) take over 50.0%

Tricare

categorical

Approximate Distinct Count 342
Approximate Unique (%) 44.9%
Missing 0
Missing (%) 0.0%
Memory Size 110.1 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 420.0 times larger than the second largest value (Average payment of 1,337.05, with a minimum and maximum of 1,337.05 and 1,337.05, respectively)

Length

Mean 83.2116
Standard Deviation 11.3956
Median 73
Minimum 73
Maximum 100

Sample

1st row Average payment of...
2nd row Average payment of...
3rd row Average payment of...
4th row Average payment of...
5th row Average payment of...

Letter

Count 43955
Lowercase Letter 41934
Space Separator 9893
Uppercase Letter 2021
Dash Punctuation 0
Decimal Number 6769
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,337.05, with a minimum and maximum of 1,337.05 and 1,337.05, respectively) take over 50.0%
  • The largest value (payment) is over 1.81 times larger than the second largest value (data)

Workers Comp

categorical

Approximate Distinct Count 50
Approximate Unique (%) 6.6%
Missing 0
Missing (%) 0.0%
Memory Size 103.7 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 712.0 times larger than the second largest value (Average payment of 10,705.34, with a minimum and maximum of 21,410.67 and 21,410.67, respectively)

Length

Mean 74.5611
Standard Deviation 5.9625
Median 73
Minimum 73
Maximum 100

Sample

1st row Payment data is no...
2nd row Payment data is no...
3rd row Average payment of...
4th row Payment data is no...
5th row Payment data is no...

Letter

Count 45415
Lowercase Letter 42518
Space Separator 9893
Uppercase Letter 2897
Dash Punctuation 0
Decimal Number 1041
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 10,705.34, with a minimum and maximum of 21,410.67 and 21,410.67, respectively) take over 50.0%

Self Pay

categorical

Approximate Distinct Count 722
Approximate Unique (%) 94.9%
Missing 0
Missing (%) 0.0%
Memory Size 118.5 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 40.0 times larger than the second largest value (#DIV/0!)

Length

Mean 94.5138
Standard Deviation 6.1708
Median 96
Minimum 7
Maximum 102

Sample

1st row Average payment of...
2nd row Average payment of...
3rd row Average payment of...
4th row Average payment of...
5th row Average payment of...

Letter

Count 42003
Lowercase Letter 41120
Space Separator 9880
Uppercase Letter 883
Dash Punctuation 0
Decimal Number 14359
  • Self Pay contains many words: 2096 words

De-identified Minimum

categorical

Approximate Distinct Count 566
Approximate Unique (%) 74.4%
Missing 0
Missing (%) 0.0%
Memory Size 53.4 KB
  • The largest value ( - ) is over 2.5 times larger than the second largest value ( 5,358 )

Length

Mean 6.9001
Standard Deviation 1.0478
Median 7
Minimum 4
Maximum 9

Sample

1st row 82,344
2nd row 117,661
3rd row 26,986
4th row 52,237
5th row 82,932

Letter

Count 0
Lowercase Letter 0
Space Separator 1672
Uppercase Letter 0
Dash Punctuation 75
Decimal Number 2885
  • The largest value (5358) is over 1.67 times larger than the second largest value (3139)

De-identified Maximum

categorical

Approximate Distinct Count 680
Approximate Unique (%) 89.4%
Missing 0
Missing (%) 0.0%
Memory Size 54.1 KB
  • The largest value ( - ) is over 25.0 times larger than the second largest value ( 5,358 )

Length

Mean 7.862
Standard Deviation 1.1089
Median 8
Minimum 5
Maximum 11

Sample

1st row 2,561,560
2nd row 748,301
3rd row 2,590,858
4th row 1,609,887
5th row 792,107

Letter

Count 0
Lowercase Letter 0
Space Separator 1672
Uppercase Letter 0
Dash Punctuation 75
Decimal Number 3543

Filename

categorical

Approximate Distinct Count 1
Approximate Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 76.5 KB

Length

Mean 38
Standard Deviation 0
Median 38
Minimum 38
Maximum 38

Sample

1st row 56-2070036_DUH_sta...
2nd row 56-2070036_DUH_sta...
3rd row 56-2070036_DUH_sta...
4th row 56-2070036_DUH_sta...
5th row 56-2070036_DUH_sta...

Letter

Count 18264
Lowercase Letter 15981
Space Separator 0
Uppercase Letter 2283
Dash Punctuation 761
Decimal Number 6849
  • Filename has words of constant length

Interactions

Correlations

Missing Values