Overview

Dataset Statistics

Number of Variables 14
Number of Rows 324
Missing Cells 477
Missing Cells (%) 10.5%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 300.3 KB
Average Row Size in Memory 949.0 B
Variable Types
  • Categorical: 14

Dataset Insights

CMS Required DRG/CPT/HCPCS has 249 (76.85%) missing values Missing
Self-Pay (estimate) has 25 (7.72%) missing values Missing
Medicare has 25 (7.72%) missing values Missing
Medicaid has 25 (7.72%) missing values Missing
Aetna has 25 (7.72%) missing values Missing
BCBS has 25 (7.72%) missing values Missing
BCBS State has 25 (7.72%) missing values Missing
Cigna has 25 (7.72%) missing values Missing
Medcost has 25 (7.72%) missing values Missing
UHC has 25 (7.72%) missing values Missing
DRG/CPT/ HCPCS has a high cardinality: 323 distinct values High Cardinality
Description has a high cardinality: 306 distinct values High Cardinality
CMH FY21 Chg (estimate) has a high cardinality: 236 distinct values High Cardinality
Self-Pay (estimate) has a high cardinality: 235 distinct values High Cardinality
Medicare has a high cardinality: 261 distinct values High Cardinality
Medicaid has a high cardinality: 256 distinct values High Cardinality
Aetna has a high cardinality: 249 distinct values High Cardinality
BCBS has a high cardinality: 235 distinct values High Cardinality
BCBS State has a high cardinality: 235 distinct values High Cardinality
Cigna has a high cardinality: 239 distinct values High Cardinality
Medcost has a high cardinality: 235 distinct values High Cardinality
UHC has a high cardinality: 235 distinct values High Cardinality
Filename has constant value "56-0529974_Charles_A_Cannon_Jr_Memorial_Hospital_Shoppable_Services.csv" Constant
Filename has constant length 71 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 249
Missing (%) 76.8%
Memory Size 4.9 KB
  • The largest value (X) is over 74.0 times larger than the second largest value (CMH offers 50 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 (50)

DRG/CPT/ HCPCS

categorical

Approximate Distinct Count 323
Approximate Unique (%) 100.0%
Missing 1
Missing (%) 0.3%
Memory Size 22.1 KB

Length

Mean 5.1362
Standard Deviation 1.0246
Median 5
Minimum 3
Maximum 11

Sample

1st row 11042
2nd row 11404
3rd row 11426
4th row 11642
5th row 11643

Letter

Count 16
Lowercase Letter 0
Space Separator 0
Uppercase Letter 16
Dash Punctuation 0
Decimal Number 1634

Description

categorical

Approximate Distinct Count 306
Approximate Unique (%) 94.7%
Missing 1
Missing (%) 0.3%
Memory Size 30.9 KB
  • The largest value (OFFICE/OUTPATIENT VISIT EST) is over 2.0 times larger than the second largest value (Automated urinalysis test)

Length

Mean 33.0031
Standard Deviation 19.6327
Median 27
Minimum 4
Maximum 139

Sample

1st row Debridement subcut...
2nd row Exc b9 lesion mrgn...
3rd row Exc b9 lesion mrgn...
4th row Excision malignant...
5th row Excision malignant...

Letter

Count 8699
Lowercase Letter 6997
Space Separator 1373
Uppercase Letter 1702
Dash Punctuation 103
Decimal Number 172

CMH FY21 Chg (estimate)

categorical

Approximate Distinct Count 236
Approximate Unique (%) 73.1%
Missing 1
Missing (%) 0.3%
Memory Size 23.6 KB
  • The largest value ( Service Not Offered At CMH ) is over 4.0 times larger than the second largest value ( 67.00 )

Length

Mean 9.8266
Standard Deviation 5.2992
Median 8
Minimum 7
Maximum 28

Sample

1st row 5,935.21
2nd row 9,175.50
3rd row 6,537.32
4th row 11,215.59
5th row 6,548.92

Letter

Count 528
Lowercase Letter 360
Space Separator 742
Uppercase Letter 168
Dash Punctuation 0
Decimal Number 1524

Self-Pay (estimate)

categorical

Approximate Distinct Count 235
Approximate Unique (%) 78.6%
Missing 25
Missing (%) 7.7%
Memory Size 21.3 KB

Length

Mean 8.0502
Standard Deviation 1.1326
Median 8
Minimum 6
Maximum 11

Sample

1st row 2,967.61
2nd row 4,587.75
3rd row 3,268.66
4th row 5,607.79
5th row 3,274.46

Letter

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

Medicare

categorical

Approximate Distinct Count 261
Approximate Unique (%) 87.3%
Missing 25
Missing (%) 7.7%
Memory Size 21.1 KB
  • The largest value (35.09) is over 1.75 times larger than the second largest value ( 202.53 )

Length

Mean 7.1237
Standard Deviation 2.1002
Median 8
Minimum 4
Maximum 11

Sample

1st row 2,552.14
2nd row 3,945.46
3rd row 2,811.05
4th row 4,822.70
5th row 2,816.03

Letter

Count 0
Lowercase Letter 0
Space Separator 396
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 1377
  • The largest value (3509) is over 1.75 times larger than the second largest value (20253)

Medicaid

categorical

Approximate Distinct Count 256
Approximate Unique (%) 85.6%
Missing 25
Missing (%) 7.7%
Memory Size 21.1 KB

Length

Mean 7.1739
Standard Deviation 2.0357
Median 8
Minimum 4
Maximum 11

Sample

1st row 2,492.79
2nd row 3,853.71
3rd row 2,745.67
4th row 4,710.55
5th row 2,750.54

Letter

Count 0
Lowercase Letter 0
Space Separator 396
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 1392

Aetna

categorical

Approximate Distinct Count 249
Approximate Unique (%) 83.3%
Missing 25
Missing (%) 7.7%
Memory Size 21.3 KB

Length

Mean 8.0569
Standard Deviation 1.5283
Median 8
Minimum 5
Maximum 11

Sample

1st row 5,341.69
2nd row 8,257.95
3rd row 5,883.59
4th row 10,094.03
5th row 5,894.02

Letter

Count 0
Lowercase Letter 0
Space Separator 614
Uppercase Letter 0
Dash Punctuation 8
Decimal Number 1417

BCBS

categorical

Approximate Distinct Count 235
Approximate Unique (%) 78.6%
Missing 25
Missing (%) 7.7%
Memory Size 21.4 KB

Length

Mean 8.1371
Standard Deviation 1.1489
Median 8
Minimum 6
Maximum 11

Sample

1st row 3,519.58
2nd row 5,441.07
3rd row 3,876.63
4th row 6,650.84
5th row 3,883.51

Letter

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

BCBS State

categorical

Approximate Distinct Count 235
Approximate Unique (%) 78.6%
Missing 25
Missing (%) 7.7%
Memory Size 21.4 KB

Length

Mean 8.1371
Standard Deviation 1.1489
Median 8
Minimum 6
Maximum 11

Sample

1st row 3,519.58
2nd row 5,441.07
3rd row 3,876.63
4th row 6,650.84
5th row 3,883.51

Letter

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

Cigna

categorical

Approximate Distinct Count 239
Approximate Unique (%) 79.9%
Missing 25
Missing (%) 7.7%
Memory Size 21.4 KB

Length

Mean 8.2809
Standard Deviation 1.2564
Median 8
Minimum 6
Maximum 11

Sample

1st row 5,044.93
2nd row 7,799.17
3rd row 5,556.72
4th row 9,533.25
5th row 5,566.58

Letter

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

Medcost

categorical

Approximate Distinct Count 235
Approximate Unique (%) 78.6%
Missing 25
Missing (%) 7.7%
Memory Size 21.4 KB

Length

Mean 8.2776
Standard Deviation 1.1899
Median 8
Minimum 7
Maximum 11

Sample

1st row 4,688.82
2nd row 7,248.64
3rd row 5,164.48
4th row 8,860.31
5th row 5,173.64

Letter

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

UHC

categorical

Approximate Distinct Count 235
Approximate Unique (%) 78.6%
Missing 25
Missing (%) 7.7%
Memory Size 21.4 KB

Length

Mean 8.2609
Standard Deviation 1.2035
Median 8
Minimum 6
Maximum 11

Sample

1st row 4,510.76
2nd row 6,973.38
3rd row 4,968.36
4th row 8,523.85
5th row 4,977.18

Letter

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

Filename

categorical

Approximate Distinct Count 1
Approximate Unique (%) 0.3%
Missing 0
Missing (%) 0.0%
Memory Size 43.0 KB

Length

Mean 71
Standard Deviation 0
Median 71
Minimum 71
Maximum 71

Sample

1st row 56-0529974_Charles...
2nd row 56-0529974_Charles...
3rd row 56-0529974_Charles...
4th row 56-0529974_Charles...
5th row 56-0529974_Charles...

Letter

Count 16848
Lowercase Letter 14256
Space Separator 0
Uppercase Letter 2592
Dash Punctuation 324
Decimal Number 2916
  • Filename has words of constant length

Missing Values