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: 178 distinct values High Cardinality
Medicare Adv - BCBS has a high cardinality: 123 distinct values High Cardinality
Medicare Adv - Humana has a high cardinality: 138 distinct values High Cardinality
Medicare Adv - United has a high cardinality: 259 distinct values High Cardinality
Medicare Adv - Other has a high cardinality: 110 distinct values High Cardinality
Aetna has a high cardinality: 94 distinct values High Cardinality
BCBS has a high cardinality: 296 distinct values High Cardinality
Cigna has a high cardinality: 111 distinct values High Cardinality
Exchange/Ambetter has a high cardinality: 61 distinct values High Cardinality
United has a high cardinality: 126 distinct values High Cardinality
Tricare has a high cardinality: 94 distinct values High Cardinality
Self Pay has a high cardinality: 531 distinct values High Cardinality
De-identified Minimum has a high cardinality: 421 distinct values High Cardinality
De-identified Maximum has a high cardinality: 452 distinct values High Cardinality
Filename has constant value "56-2070036_DRaH_standardcharges_drg.csv" Constant
Filename has constant length 39 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 178
Approximate Unique (%) 23.4%
Missing 0
Missing (%) 0.0%
Memory Size 106.4 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 584.0 times larger than the second largest value (Average payment of 10,072.85, with a minimum and maximum of 10,072.85 and 10,072.85, respectively)

Length

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

Letter

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

Medicare Adv - BCBS

categorical

Approximate Distinct Count 123
Approximate Unique (%) 16.2%
Missing 0
Missing (%) 0.0%
Memory Size 105.2 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 639.0 times larger than the second largest value (Average payment of 10,059.62, with a minimum and maximum of 8,995.00 and 10,842.68, respectively)

Length

Mean 76.5598
Standard Deviation 8.1744
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 45050
Lowercase Letter 42372
Space Separator 9893
Uppercase Letter 2678
Dash Punctuation 0
Decimal Number 2343
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 10,059.62, with a minimum and maximum of 8,995.00 and 10,842.68, respectively) take over 50.0%

Medicare Adv - Humana

categorical

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

Length

Mean 76.9777
Standard Deviation 8.5246
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 44975
Lowercase Letter 42342
Space Separator 9893
Uppercase Letter 2633
Dash Punctuation 0
Decimal Number 2623
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,009.11, with a minimum and maximum of 1,009.11 and 1,009.11, respectively) take over 50.0%

Medicare Adv - United

categorical

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

Length

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

Letter

Count 44370
Lowercase Letter 42100
Space Separator 9893
Uppercase Letter 2270
Dash Punctuation 0
Decimal Number 4955
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 10,052.79, with a minimum and maximum of 10,052.79 and 10,052.79, 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 110
Approximate Unique (%) 14.4%
Missing 0
Missing (%) 0.0%
Memory Size 105.0 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 216.67 times larger than the second largest value (Average payment of 2,329.07, with a minimum and maximum of 2,329.07 and 2,329.07, respectively)

Length

Mean 76.2339
Standard Deviation 7.8504
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 45105
Lowercase Letter 42394
Space Separator 9893
Uppercase Letter 2711
Dash Punctuation 0
Decimal Number 2129
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 2,329.07, with a minimum and maximum of 2,329.07 and 2,329.07, respectively) take over 50.0%

Aetna

categorical

Approximate Distinct Count 94
Approximate Unique (%) 12.3%
Missing 0
Missing (%) 0.0%
Memory Size 104.9 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 93.29 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 76.0894
Standard Deviation 7.618
Median 73
Minimum 73
Maximum 98

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 45120
Lowercase Letter 42400
Space Separator 9893
Uppercase Letter 2720
Dash Punctuation 0
Decimal Number 2028
  • 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 296
Approximate Unique (%) 38.9%
Missing 0
Missing (%) 0.0%
Memory Size 109.1 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 466.0 times larger than the second largest value (Average payment of 1,707.65, with a minimum and maximum of 1,707.65 and 1,707.65, respectively)

Length

Mean 81.8502
Standard Deviation 11.1652
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 44185
Lowercase Letter 42026
Space Separator 9893
Uppercase Letter 2159
Dash Punctuation 0
Decimal Number 5851
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,707.65, with a minimum and maximum of 1,707.65 and 1,707.65, respectively) take over 50.0%
  • The largest value (payment) is over 1.63 times larger than the second largest value (available)

Cigna

categorical

Approximate Distinct Count 111
Approximate Unique (%) 14.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 213.67 times larger than the second largest value (Average payment of 10,863.00, with a minimum and maximum of 10,863.00 and 10,863.00, respectively)

Length

Mean 76.6478
Standard Deviation 8.4578
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 45060
Lowercase Letter 42376
Space Separator 9893
Uppercase Letter 2684
Dash Punctuation 0
Decimal Number 2419
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 10,863.00, with a minimum and maximum of 10,863.00 and 10,863.00, respectively) take over 50.0%

Exchange/Ambetter

categorical

Approximate Distinct Count 61
Approximate Unique (%) 8.0%
Missing 0
Missing (%) 0.0%
Memory Size 103.9 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 701.0 times larger than the second largest value (Average payment of 1,825.98, with a minimum and maximum of 3,651.95 and 3,651.95, respectively)

Length

Mean 74.8081
Standard Deviation 6.198
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 45360
Lowercase Letter 42496
Space Separator 9893
Uppercase Letter 2864
Dash Punctuation 0
Decimal Number 1197
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,825.98, with a minimum and maximum of 3,651.95 and 3,651.95, respectively) take over 50.0%

Medcost

categorical

Approximate Distinct Count 25
Approximate Unique (%) 3.3%
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 737.0 times larger than the second largest value (Average payment of 10,235.45, with a minimum and maximum of 10,235.45 and 10,235.45, respectively)

Length

Mean 73.728
Standard Deviation 4.044
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 45540
Lowercase Letter 42568
Space Separator 9893
Uppercase Letter 2972
Dash Punctuation 0
Decimal Number 483
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 10,235.45, with a minimum and maximum of 10,235.45 and 10,235.45, respectively) take over 50.0%

United

categorical

Approximate Distinct Count 126
Approximate Unique (%) 16.6%
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 55.27 times larger than the second largest value (Average payment of 4,753.00, with a minimum and maximum of 4,753.00 and 4,753.00, respectively)

Length

Mean 77.4192
Standard Deviation 8.8505
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 44895
Lowercase Letter 42310
Space Separator 9893
Uppercase Letter 2585
Dash Punctuation 0
Decimal Number 2911
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 4,753.00, with a minimum and maximum of 4,753.00 and 4,753.00, respectively) take over 50.0%

Other Mgd Care

categorical

Approximate Distinct Count 35
Approximate Unique (%) 4.6%
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 241.33 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 73.9763
Standard Deviation 4.3805
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 45475
Lowercase Letter 42542
Space Separator 9893
Uppercase Letter 2933
Dash Punctuation 0
Decimal Number 663
  • 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 94
Approximate Unique (%) 12.3%
Missing 0
Missing (%) 0.0%
Memory Size 104.6 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 668.0 times larger than the second largest value (Average payment of 1,056.27, with a minimum and maximum of 1,056.27 and 1,056.27, respectively)

Length

Mean 75.7411
Standard Deviation 7.3689
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 45195
Lowercase Letter 42430
Space Separator 9893
Uppercase Letter 2765
Dash Punctuation 0
Decimal Number 1807
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 1,056.27, with a minimum and maximum of 1,056.27 and 1,056.27, respectively) take over 50.0%

Workers Comp

categorical

Approximate Distinct Count 15
Approximate Unique (%) 2.0%
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 747.0 times larger than the second largest value (Average payment of 12,394.80, with a minimum and maximum of 12,394.80 and 12,394.80, respectively)

Length

Mean 73.4376
Standard Deviation 3.2002
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 45590
Lowercase Letter 42588
Space Separator 9893
Uppercase Letter 3002
Dash Punctuation 0
Decimal Number 291
  • The top 2 categories (Payment data is not available for this DRG for this entity for this payer, Average payment of 12,394.80, with a minimum and maximum of 12,394.80 and 12,394.80, respectively) take over 50.0%

Self Pay

categorical

Approximate Distinct Count 531
Approximate Unique (%) 69.8%
Missing 0
Missing (%) 0.0%
Memory Size 114.1 KB
  • The largest value (Payment data is not available for this DRG for this entity for this payer) is over 231.0 times larger than the second largest value (Average payment of 1,587.02, with a minimum and maximum of 184.60 and 3,458.28, respectively)

Length

Mean 88.5808
Standard Deviation 10.3481
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 43010
Lowercase Letter 41556
Space Separator 9893
Uppercase Letter 1454
Dash Punctuation 0
Decimal Number 10299
  • Self Pay contains many words: 1399 words

De-identified Minimum

categorical

Approximate Distinct Count 421
Approximate Unique (%) 55.3%
Missing 0
Missing (%) 0.0%
Memory Size 53.0 KB
  • The largest value ( - ) is over 42.71 times larger than the second largest value ( 3,247 )

Length

Mean 6.318
Standard Deviation 1.2167
Median 7
Minimum 4
Maximum 9

Sample

1st row -
2nd row -
3rd row 103,190
4th row 62,876
5th row -

Letter

Count 0
Lowercase Letter 0
Space Separator 2120
Uppercase Letter 0
Dash Punctuation 299
Decimal Number 1957

De-identified Maximum

categorical

Approximate Distinct Count 452
Approximate Unique (%) 59.4%
Missing 0
Missing (%) 0.0%
Memory Size 53.2 KB
  • The largest value ( - ) is over 74.75 times larger than the second largest value ( 12,713 )

Length

Mean 6.636
Standard Deviation 1.3756
Median 7
Minimum 5
Maximum 9

Sample

1st row -
2nd row -
3rd row 211,296
4th row 70,554
5th row -

Letter

Count 0
Lowercase Letter 0
Space Separator 2120
Uppercase Letter 0
Dash Punctuation 299
Decimal Number 2169

Filename

categorical

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

Length

Mean 39
Standard Deviation 0
Median 39
Minimum 39
Maximum 39

Sample

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

Letter

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

Interactions

Correlations

Missing Values