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.7 MB
Average Row Size in Memory 2.3 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: 188 distinct values High Cardinality
Medicare Adv - BCBS has a high cardinality: 148 distinct values High Cardinality
Medicare Adv - Humana has a high cardinality: 172 distinct values High Cardinality
Medicare Adv - United has a high cardinality: 258 distinct values High Cardinality
Medicare Adv - Other has a high cardinality: 77 distinct values High Cardinality
Aetna has a high cardinality: 136 distinct values High Cardinality
BCBS has a high cardinality: 303 distinct values High Cardinality
Cigna has a high cardinality: 119 distinct values High Cardinality
United has a high cardinality: 143 distinct values High Cardinality
Other Mgd Care has a high cardinality: 148 distinct values High Cardinality
Tricare has a high cardinality: 90 distinct values High Cardinality
Self Pay has a high cardinality: 551 distinct values High Cardinality
De-identified Minimum has a high cardinality: 420 distinct values High Cardinality
De-identified Maximum has a high cardinality: 462 distinct values High Cardinality
Filename has constant value "56-2070036_DRH_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 188
Approximate Unique (%) 24.7%
Missing 0
Missing (%) 0.0%
Memory Size 106.7 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 286.5 times larger than the second largest value (Average payment of 11,389.24, with a minimum and maximum of 11,389.24 and 11,389.24, respectively)

Length

Mean 78.5874
Standard Deviation 9.7954
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 44720
Lowercase Letter 42240
Space Separator 9893
Uppercase Letter 2480
Dash Punctuation 0
Decimal Number 3697
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 11,389.24, with a minimum and maximum of 11,389.24 and 11,389.24, respectively) take over 50.0%

Medicare Adv - BCBS

categorical

Approximate Distinct Count 148
Approximate Unique (%) 19.4%
Missing 0
Missing (%) 0.0%
Memory Size 105.8 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 614.0 times larger than the second largest value (Average payment of 10,101.37, with a minimum and maximum of 10,101.37 and 10,101.37, respectively)

Length

Mean 77.3706
Standard Deviation 8.9611
Median 73
Minimum 73
Maximum 97

Sample

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

Letter

Count 44925
Lowercase Letter 42322
Space Separator 9893
Uppercase Letter 2603
Dash Punctuation 0
Decimal Number 2885
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 10,101.37, with a minimum and maximum of 10,101.37 and 10,101.37, respectively) take over 50.0%

Medicare Adv - Humana

categorical

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

Length

Mean 78.0039
Standard Deviation 9.358
Median 73
Minimum 73
Maximum 97

Sample

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

Letter

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

Medicare Adv - United

categorical

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

Length

Mean 80.59
Standard Deviation 10.6847
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 Average payment of...
5th row Payment data is no...

Letter

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

Medicare Adv - Other

categorical

Approximate Distinct Count 77
Approximate Unique (%) 10.1%
Missing 0
Missing (%) 0.0%
Memory Size 104.2 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 685.0 times larger than the second largest value (Average payment of 10,085.12, with a minimum and maximum of 9,832.97 and 10,337.27, respectively)

Length

Mean 75.1971
Standard Deviation 6.6357
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 Average payment of...
5th row Payment data is no...

Letter

Count 45280
Lowercase Letter 42464
Space Separator 9893
Uppercase Letter 2816
Dash Punctuation 0
Decimal Number 1457
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 10,085.12, with a minimum and maximum of 9,832.97 and 10,337.27, respectively) take over 50.0%

Aetna

categorical

Approximate Distinct Count 136
Approximate Unique (%) 17.9%
Missing 0
Missing (%) 0.0%
Memory Size 105.9 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 60.0 times larger than the second largest value (Average payment of 3,483.00, with a minimum and maximum of 3,483.00 and 3,483.00, respectively)

Length

Mean 77.5401
Standard Deviation 8.7989
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 44855
Lowercase Letter 42294
Space Separator 9893
Uppercase Letter 2561
Dash Punctuation 0
Decimal Number 2987
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 3,483.00, with a minimum and maximum of 3,483.00 and 3,483.00, respectively) take over 50.0%

BCBS

categorical

Approximate Distinct Count 303
Approximate Unique (%) 39.8%
Missing 0
Missing (%) 0.0%
Memory Size 109.3 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 459.0 times larger than the second largest value (Average payment of 1,722.16, with a minimum and maximum of 14.88 and 3,221.53, respectively)

Length

Mean 82.0644
Standard Deviation 11.2291
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 44150
Lowercase Letter 42012
Space Separator 9893
Uppercase Letter 2138
Dash Punctuation 0
Decimal Number 6007
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,722.16, with a minimum and maximum of 14.88 and 3,221.53, respectively) take over 50.0%
  • The largest value (payment) is over 1.66 times larger than the second largest value (available)

Cigna

categorical

Approximate Distinct Count 119
Approximate Unique (%) 15.6%
Missing 0
Missing (%) 0.0%
Memory Size 105.3 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 159.25 times larger than the second largest value (Average payment of 12,699.00, with a minimum and maximum of 12,699.00 and 12,699.00, respectively)

Length

Mean 76.7017
Standard Deviation 8.4303
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 Payment data is no...
5th row Payment data is no...

Letter

Count 45040
Lowercase Letter 42368
Space Separator 9893
Uppercase Letter 2672
Dash Punctuation 0
Decimal Number 2456
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 12,699.00, with a minimum and maximum of 12,699.00 and 12,699.00, respectively) take over 50.0%

Exchange/Ambetter

categorical

Approximate Distinct Count 36
Approximate Unique (%) 4.7%
Missing 0
Missing (%) 0.0%
Memory Size 103.3 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 726.0 times larger than the second largest value (Average payment of 1,665.60, with a minimum and maximum of 776.53 and 4,437.93, respectively)

Length

Mean 74.0657
Standard Deviation 4.8686
Median 73
Minimum 73
Maximum 97

Sample

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

Letter

Count 45485
Lowercase Letter 42546
Space Separator 9893
Uppercase Letter 2939
Dash Punctuation 0
Decimal Number 709
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,665.60, with a minimum and maximum of 776.53 and 4,437.93, respectively) take over 50.0%

Medcost

categorical

Approximate Distinct Count 18
Approximate Unique (%) 2.4%
Missing 0
Missing (%) 0.0%
Memory Size 102.9 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 744.0 times larger than the second largest value (Average payment of 1,095.33, with a minimum and maximum of 229.43 and 1,914.67, respectively)

Length

Mean 73.5033
Standard Deviation 3.3431
Median 73
Minimum 73
Maximum 97

Sample

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

Letter

Count 45575
Lowercase Letter 42582
Space Separator 9893
Uppercase Letter 2993
Dash Punctuation 0
Decimal Number 334
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,095.33, with a minimum and maximum of 229.43 and 1,914.67, respectively) take over 50.0%

United

categorical

Approximate Distinct Count 143
Approximate Unique (%) 18.8%
Missing 0
Missing (%) 0.0%
Memory Size 105.8 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 152.75 times larger than the second largest value (Average payment of 6,421.00, with a minimum and maximum of 6,421.00 and 6,421.00, respectively)

Length

Mean 77.3114
Standard Deviation 8.7411
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 Payment data is no...
5th row Payment data is no...

Letter

Count 44910
Lowercase Letter 42316
Space Separator 9893
Uppercase Letter 2594
Dash Punctuation 0
Decimal Number 2846
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 6,421.00, with a minimum and maximum of 6,421.00 and 6,421.00, respectively) take over 50.0%

Other Mgd Care

categorical

Approximate Distinct Count 148
Approximate Unique (%) 19.4%
Missing 0
Missing (%) 0.0%
Memory Size 105.9 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 306.5 times larger than the second largest value (Average payment of 954.87, with a minimum and maximum of 954.87 and 954.87, respectively)

Length

Mean 77.4678
Standard Deviation 9.1428
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 Payment data is no...
5th row Payment data is no...

Letter

Count 44920
Lowercase Letter 42320
Space Separator 9893
Uppercase Letter 2600
Dash Punctuation 0
Decimal Number 2983
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 954.87, with a minimum and maximum of 954.87 and 954.87, respectively) take over 50.0%

Tricare

categorical

Approximate Distinct Count 90
Approximate Unique (%) 11.8%
Missing 0
Missing (%) 0.0%
Memory Size 104.5 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 672.0 times larger than the second largest value (Average payment of 1,337.50, with a minimum and maximum of 2,675.00 and 2,675.00, respectively)

Length

Mean 75.6058
Standard Deviation 7.1912
Median 73
Minimum 73
Maximum 97

Sample

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

Letter

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

Workers Comp

categorical

Approximate Distinct Count 24
Approximate Unique (%) 3.2%
Missing 0
Missing (%) 0.0%
Memory Size 103.1 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 738.0 times larger than the second largest value (Average payment of 10,638.63, with a minimum and maximum of 9,847.75 and 11,707.18, respectively)

Length

Mean 73.7148
Standard Deviation 4.0547
Median 73
Minimum 73
Maximum 97

Sample

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

Letter

Count 45545
Lowercase Letter 42570
Space Separator 9893
Uppercase Letter 2975
Dash Punctuation 0
Decimal Number 475
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 10,638.63, with a minimum and maximum of 9,847.75 and 11,707.18, respectively) take over 50.0%

Self Pay

categorical

Approximate Distinct Count 551
Approximate Unique (%) 72.4%
Missing 0
Missing (%) 0.0%
Memory Size 114.5 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 211.0 times larger than the second largest value (Average payment of 1,113.91, with a minimum and maximum of 459.30 and 7,155.04, respectively)

Length

Mean 89.0972
Standard Deviation 10.0439
Median 94
Minimum 73
Maximum 100

Sample

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

Letter

Count 42910
Lowercase Letter 41516
Space Separator 9893
Uppercase Letter 1394
Dash Punctuation 0
Decimal Number 10652
  • Self Pay contains many words: 1461 words

De-identified Minimum

categorical

Approximate Distinct Count 420
Approximate Unique (%) 55.2%
Missing 0
Missing (%) 0.0%
Memory Size 52.9 KB
  • The largest value ( - ) is over 29.5 times larger than the second largest value ( 2,883 )

Length

Mean 6.2326
Standard Deviation 1.2711
Median 7
Minimum 4
Maximum 9

Sample

1st row -
2nd row -
3rd row 37,363
4th row 9,405
5th row -

Letter

Count 0
Lowercase Letter 0
Space Separator 2112
Uppercase Letter 0
Dash Punctuation 295
Decimal Number 1943

De-identified Maximum

categorical

Approximate Distinct Count 462
Approximate Unique (%) 60.7%
Missing 0
Missing (%) 0.0%
Memory Size 53.3 KB
  • The largest value ( - ) is over 147.5 times larger than the second largest value ( 32,532 )

Length

Mean 6.724
Standard Deviation 1.4272
Median 7
Minimum 5
Maximum 9

Sample

1st row -
2nd row -
3rd row 173,793
4th row 80,186
5th row -

Letter

Count 0
Lowercase Letter 0
Space Separator 2112
Uppercase Letter 0
Dash Punctuation 295
Decimal Number 2246

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_DRH_sta...
2nd row 56-2070036_DRH_sta...
3rd row 56-2070036_DRH_sta...
4th row 56-2070036_DRH_sta...
5th row 56-2070036_DRH_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