Overview

Dataset Statistics

Number of Variables 14
Number of Rows 1282
Missing Cells 12967
Missing Cells (%) 72.2%
Duplicate Rows 969
Duplicate Rows (%) 75.6%
Total Size in Memory 790.9 KB
Average Row Size in Memory 631.7 B
Variable Types
  • Categorical: 14

Dataset Insights

CMS Required DRG/CPT/HCPCS has 1207 (94.15%) missing values Missing
DRG/CPT/ HCPCS has 971 (75.74%) missing values Missing
Description has 971 (75.74%) missing values Missing
CMH FY21 Chg (estimate) has 971 (75.74%) missing values Missing
Self-Pay (estimate) has 983 (76.68%) missing values Missing
Medicare has 983 (76.68%) missing values Missing
Medicaid has 983 (76.68%) missing values Missing
Aetna has 983 (76.68%) missing values Missing
BCBS has 983 (76.68%) missing values Missing
BCBS State has 983 (76.68%) missing values Missing
Cigna has 983 (76.68%) missing values Missing
Medcost has 983 (76.68%) missing values Missing
UHC has 983 (76.68%) missing values Missing
Dataset has 969 (75.59%) duplicate rows Duplicates
DRG/CPT/ HCPCS has a high cardinality: 311 distinct values High Cardinality
Description has a high cardinality: 291 distinct values High Cardinality
CMH FY21 Chg (estimate) has a high cardinality: 245 distinct values High Cardinality
Self-Pay (estimate) has a high cardinality: 244 distinct values High Cardinality
Medicare has a high cardinality: 142 distinct values High Cardinality
Medicaid has a high cardinality: 258 distinct values High Cardinality
Aetna has a high cardinality: 240 distinct values High Cardinality
BCBS has a high cardinality: 240 distinct values High Cardinality
BCBS State has a high cardinality: 240 distinct values High Cardinality
Cigna has a high cardinality: 247 distinct values High Cardinality
Medcost has a high cardinality: 244 distinct values High Cardinality
UHC has a high cardinality: 244 distinct values High Cardinality
Filename has constant value "56-0510824_Watauga_Medical_Center_Shoppable_Services.csv" Constant
Filename has constant length 56 Constant Length
DRG/CPT/ HCPCS has all distinct values Unique
  • 1
  • 2
  • 3

Variables

CMS Required DRG/CPT/HCPCS

categorical

Approximate Distinct Count 2
Approximate Unique (%) 2.7%
Missing 1207
Missing (%) 94.2%
Memory Size 4.9 KB
  • The largest value (X) is over 74.0 times larger than the second largest value (WMC offers 62 of the 74 shoppable services that CMS requires to be reported)

Length

Mean 1.9867
Standard Deviation 8.5448
Median 1
Minimum 1
Maximum 75

Sample

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

Letter

Count 132
Lowercase Letter 52
Space Separator 13
Uppercase Letter 80
Dash Punctuation 0
Decimal Number 4
  • The largest value (x) is over 74.0 times larger than the second largest value (62)

DRG/CPT/ HCPCS

categorical

Approximate Distinct Count 311
Approximate Unique (%) 100.0%
Missing 971
Missing (%) 75.7%
Memory Size 21.2 KB

Length

Mean 4.9035
Standard Deviation 0.979
Median 5
Minimum 3
Maximum 11

Sample

1st row 166
2nd row 190
3rd row 243
4th row 247
5th row 286

Letter

Count 9
Lowercase Letter 0
Space Separator 0
Uppercase Letter 9
Dash Punctuation 0
Decimal Number 1511

Description

categorical

Approximate Distinct Count 291
Approximate Unique (%) 93.6%
Missing 971
Missing (%) 75.7%
Memory Size 30.5 KB

Length

Mean 35.5016
Standard Deviation 19.5056
Median 28
Minimum 4
Maximum 139

Sample

1st row Other resp system...
2nd row Chronic obstructi...
3rd row Permanent cardiac...
4th row Perc cardiovasc p...
5th row Circulatory disor...

Letter

Count 9125
Lowercase Letter 7636
Space Separator 1413
Uppercase Letter 1489
Dash Punctuation 115
Decimal Number 126

CMH FY21 Chg (estimate)

categorical

Approximate Distinct Count 245
Approximate Unique (%) 78.8%
Missing 971
Missing (%) 75.7%
Memory Size 22.6 KB
  • The largest value ( Service Not Offered At WMC ) is over 2.0 times larger than the second largest value ( 298.00 )

Length

Mean 9.5145
Standard Deviation 3.9926
Median 8
Minimum 7
Maximum 28

Sample

1st row 65,677.05
2nd row 23,087.01
3rd row 43,900.43
4th row 70,032.53
5th row 44,545.16

Letter

Count 264
Lowercase Letter 180
Space Separator 670
Uppercase Letter 84
Dash Punctuation 0
Decimal Number 1618

Self-Pay (estimate)

categorical

Approximate Distinct Count 244
Approximate Unique (%) 81.6%
Missing 983
Missing (%) 76.7%
Memory Size 21.5 KB

Length

Mean 8.5385
Standard Deviation 1.4543
Median 8
Minimum 6
Maximum 11

Sample

1st row 32,838.53
2nd row 11,543.50
3rd row 21,950.21
4th row 35,016.26
5th row 22,272.58

Letter

Count 0
Lowercase Letter 0
Space Separator 598
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 1555

Medicare

categorical

Approximate Distinct Count 142
Approximate Unique (%) 47.5%
Missing 983
Missing (%) 76.7%
Memory Size 21.2 KB

Length

Mean 7.505
Standard Deviation 2.2709
Median 8
Minimum 4
Maximum 11

Sample

1st row 24,408.80
2nd row 7,238.85
3rd row 16,312.04
4th row 12,805.65
5th row 14,260.63

Letter

Count 0
Lowercase Letter 0
Space Separator 462
Uppercase Letter 0
Dash Punctuation 11
Decimal Number 1394

Medicaid

categorical

Approximate Distinct Count 258
Approximate Unique (%) 86.3%
Missing 983
Missing (%) 76.7%
Memory Size 21.3 KB

Length

Mean 8.1137
Standard Deviation 1.6055
Median 7
Minimum 5
Maximum 11

Sample

1st row 30,736.86
2nd row 10,804.72
3rd row 20,545.40
4th row 32,775.22
5th row 20,847.13

Letter

Count 0
Lowercase Letter 0
Space Separator 600
Uppercase Letter 0
Dash Punctuation 1
Decimal Number 1431

Aetna

categorical

Approximate Distinct Count 240
Approximate Unique (%) 80.3%
Missing 983
Missing (%) 76.7%
Memory Size 21.5 KB

Length

Mean 8.6957
Standard Deviation 1.4761
Median 8
Minimum 7
Maximum 11

Sample

1st row 55,825.49
2nd row 19,623.95
3rd row 37,315.36
4th row 59,527.65
5th row 37,863.38

Letter

Count 0
Lowercase Letter 0
Space Separator 598
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 1601

BCBS

categorical

Approximate Distinct Count 240
Approximate Unique (%) 80.3%
Missing 983
Missing (%) 76.7%
Memory Size 21.5 KB

Length

Mean 8.6455
Standard Deviation 1.4751
Median 8
Minimum 5
Maximum 11

Sample

1st row 51,198.61
2nd row 16,529.20
3rd row 37,918.82
4th row 30,559.07
5th row 31,712.27

Letter

Count 0
Lowercase Letter 0
Space Separator 604
Uppercase Letter 0
Dash Punctuation 3
Decimal Number 1576

BCBS State

categorical

Approximate Distinct Count 240
Approximate Unique (%) 80.3%
Missing 983
Missing (%) 76.7%
Memory Size 21.5 KB

Length

Mean 8.6455
Standard Deviation 1.4751
Median 8
Minimum 5
Maximum 11

Sample

1st row 51,198.61
2nd row 16,529.20
3rd row 37,918.82
4th row 30,559.07
5th row 31,712.27

Letter

Count 0
Lowercase Letter 0
Space Separator 604
Uppercase Letter 0
Dash Punctuation 3
Decimal Number 1576

Cigna

categorical

Approximate Distinct Count 247
Approximate Unique (%) 82.6%
Missing 983
Missing (%) 76.7%
Memory Size 21.5 KB

Length

Mean 8.7057
Standard Deviation 1.5107
Median 8
Minimum 6
Maximum 11

Sample

1st row 55,825.49
2nd row 19,623.95
3rd row 37,315.36
4th row 59,527.65
5th row 37,863.38

Letter

Count 0
Lowercase Letter 0
Space Separator 598
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 1598

Medcost

categorical

Approximate Distinct Count 244
Approximate Unique (%) 81.6%
Missing 983
Missing (%) 76.7%
Memory Size 21.5 KB

Length

Mean 8.6823
Standard Deviation 1.4824
Median 8
Minimum 6
Maximum 11

Sample

1st row 48,601.02
2nd row 17,084.38
3rd row 32,486.32
4th row 51,824.07
5th row 32,963.41

Letter

Count 0
Lowercase Letter 0
Space Separator 598
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 1591

UHC

categorical

Approximate Distinct Count 244
Approximate Unique (%) 81.6%
Missing 983
Missing (%) 76.7%
Memory Size 21.5 KB

Length

Mean 8.689
Standard Deviation 1.4838
Median 8
Minimum 6
Maximum 11

Sample

1st row 49,914.56
2nd row 17,546.12
3rd row 33,364.33
4th row 53,224.72
5th row 33,854.32

Letter

Count 0
Lowercase Letter 0
Space Separator 598
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 1593

Filename

categorical

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

Length

Mean 56
Standard Deviation 0
Median 56
Minimum 56
Maximum 56

Sample

1st row 56-0510824_Watauga...
2nd row 56-0510824_Watauga...
3rd row 56-0510824_Watauga...
4th row 56-0510824_Watauga...
5th row 56-0510824_Watauga...

Letter

Count 51280
Lowercase Letter 44870
Space Separator 0
Uppercase Letter 6410
Dash Punctuation 1282
Decimal Number 11538
  • Filename has words of constant length

Missing Values