Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 100 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 13.0 KiB |
| Average record size in memory | 133.3 B |
Variable types
| Numeric | 12 |
|---|---|
| DateTime | 3 |
Dataset
| Description | 당뇨병 환자들이 시행한 혈액 검사 결과 데이터. 검사 항목은 HbA1c, BUN, Creatinine, AST, ALT, MDRD-eGFR, Total Cholesterol, Triglyceride, HDL, LDL. - HbA1c(당화혈색소): 혈액 속 적혈구 내 혈색소에 포도당 일부가 결합한 상태. 일반 혈당 검사가 검사 시점 혈당만을 알 수 있는데 반해 당화혈색소를 통해 3개월 간의 평균 혈당을 알 수 있음 - AST(Aspartate aminotransferase. GOT(Glutamic Oxalacetic Transaminase)), ALT(alanine aminotransferase, GPT(glutamic pyruvate transaminase)): 간세포 손상을 반영하는 아미노전이효소(Aminotransferases)로 기본적인 간기능검사 항목임 - BUN(Blood Urea Nitrogen): 간세포 손상이나 신장의 기능을 평가할 수 있는 항목 - Creatinine: 근육에서 크레틴(Creatine)으로부터 생성되며 신장 기능 이외의 영향이 적어 신기능을 평가하는데 유용함 - MDRD-eGFR(Modification of Diet in Renal Disease Study, MDRD-Estimated Glomerular Filtration Rate, eGFR): 혈액 내 크레아티닌 수치를 측정하고 그 결과를 MDRD공식을 사용하여 계산해 신장이 얼마나 잘 기능 하는지를 나태내는 수치 - Total Cholesterol(TC, 총콜레스테롤) : 혈액 내에 있는 모든 콜레스테롤을 뜻함 - Triglyceride(TG, 중성지방): 혈 중 트리글리세라이드의 양을 측정. 혈 중 트리글리세라이드가 증가하는 이유는 분명하지 않으나 심혈관 질환으로 진행될 위험의 증가와 관련이 있음 - HDL(High Density Lipoprotein) Cholesterol: 좋은 콜레스테롤이라고도 불리는 고밀도 지단백 콜레스테롤로 콜레스테롤을 흡수하여 간으로 다시 운반함. 높은 HDL cholesterol은 심장질환과 뇌졸중 위험을 낮출 수 있음 - LDL(Low Density Lipoprotein) Cholesterol: 나쁜 콜레스테롤이라고도 불리는 저밀도 지단백 콜레스테롤. 신체 콜레스테롤의 대부분을 차지하며 수치가 높으면 심장질환 및 뇌놀중 위험이 높아짐 |
|---|---|
| Author | 가톨릭대학교 은평성모병원 |
| URL | http://cmcdata.net/data/dataset/diabetes_lab2-eunpyeong |
A1C_VAL is highly overall correlated with A1C_VAL_C | High correlation |
A1C_VAL_C is highly overall correlated with A1C_VAL | High correlation |
BUN_VAL is highly overall correlated with Cr_VAL and 1 other fields | High correlation |
Cr_VAL is highly overall correlated with BUN_VAL and 1 other fields | High correlation |
AST_VAL is highly overall correlated with ALT_VAL | High correlation |
ALT_VAL is highly overall correlated with AST_VAL | High correlation |
MDRD_VAL is highly overall correlated with BUN_VAL and 1 other fields | High correlation |
TC_VAL is highly overall correlated with LDL_VAL | High correlation |
LDL_VAL is highly overall correlated with TC_VAL | High correlation |
RID has unique values | Unique |
MDRD_VAL has unique values | Unique |
Reproduction
| Analysis started | 2023-10-08 18:57:01.497470 |
|---|---|
| Analysis finished | 2023-10-08 18:57:36.986103 |
| Duration | 35.49 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
RID
Real number (ℝ)
UNIQUE
| Distinct | 100 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50.5 |
| Minimum | 1 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5.95 |
| Q1 | 25.75 |
| median | 50.5 |
| Q3 | 75.25 |
| 95-th percentile | 95.05 |
| Maximum | 100 |
| Range | 99 |
| Interquartile range (IQR) | 49.5 |
Descriptive statistics
| Standard deviation | 29.011492 |
|---|---|
| Coefficient of variation (CV) | 0.57448499 |
| Kurtosis | -1.2 |
| Mean | 50.5 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | 0 |
| Sum | 5050 |
| Variance | 841.66667 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 1 | 1.0% |
| 65 | 1 | 1.0% |
| 75 | 1 | 1.0% |
| 74 | 1 | 1.0% |
| 73 | 1 | 1.0% |
| 72 | 1 | 1.0% |
| 71 | 1 | 1.0% |
| 70 | 1 | 1.0% |
| 69 | 1 | 1.0% |
| 68 | 1 | 1.0% |
| Other values (90) | 90 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 100 | 1 | |
| 99 | 1 | |
| 98 | 1 | |
| 97 | 1 | |
| 96 | 1 | |
| 95 | 1 | |
| 94 | 1 | |
| 93 | 1 | |
| 92 | 1 | |
| 91 | 1 |
A1C_DATE
Date
| Distinct | 93 |
|---|---|
| Distinct (%) | 93.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.0 B |
| Minimum | 2015-10-01 00:00:00 |
|---|---|
| Maximum | 2020-01-07 00:00:00 |
Histogram with fixed size bins (bins=50)
A1C_VAL
Real number (ℝ)
HIGH CORRELATION
| Distinct | 51 |
|---|---|
| Distinct (%) | 51.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.158 |
| Minimum | 4.7 |
|---|---|
| Maximum | 14.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 4.7 |
|---|---|
| 5-th percentile | 5.695 |
| Q1 | 6.5 |
| median | 7.3 |
| Q3 | 9.9 |
| 95-th percentile | 12.805 |
| Maximum | 14.7 |
| Range | 10 |
| Interquartile range (IQR) | 3.4 |
Descriptive statistics
| Standard deviation | 2.2409495 |
|---|---|
| Coefficient of variation (CV) | 0.27469349 |
| Kurtosis | -0.058208298 |
| Mean | 8.158 |
| Median Absolute Deviation (MAD) | 1.1 |
| Skewness | 0.9242083 |
| Sum | 815.8 |
| Variance | 5.0218545 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6.5 | 6 | 6.0% |
| 6.6 | 6 | 6.0% |
| 7.1 | 5 | 5.0% |
| 8.0 | 5 | 5.0% |
| 11.0 | 4 | 4.0% |
| 5.8 | 3 | 3.0% |
| 8.3 | 3 | 3.0% |
| 6.0 | 3 | 3.0% |
| 6.8 | 3 | 3.0% |
| 6.4 | 3 | 3.0% |
| Other values (41) | 59 |
| Value | Count | Frequency (%) |
| 4.7 | 1 | 1.0% |
| 5.4 | 1 | 1.0% |
| 5.5 | 1 | 1.0% |
| 5.6 | 2 | |
| 5.7 | 2 | |
| 5.8 | 3 | |
| 5.9 | 1 | 1.0% |
| 6.0 | 3 | |
| 6.2 | 2 | |
| 6.3 | 3 |
| Value | Count | Frequency (%) |
| 14.7 | 1 | |
| 13.2 | 1 | |
| 13.1 | 2 | |
| 12.9 | 1 | |
| 12.8 | 1 | |
| 12.4 | 2 | |
| 11.9 | 1 | |
| 11.7 | 1 | |
| 11.5 | 1 | |
| 11.1 | 1 |
A1C_VAL_C
Real number (ℝ)
HIGH CORRELATION
| Distinct | 11 |
|---|---|
| Distinct (%) | 11.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.73 |
| Minimum | 4 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 6 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 14 |
| Range | 10 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.2823654 |
|---|---|
| Coefficient of variation (CV) | 0.29526073 |
| Kurtosis | -0.18890084 |
| Mean | 7.73 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.83978775 |
| Sum | 773 |
| Variance | 5.2091919 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 6 | 29 | |
| 7 | 17 | |
| 8 | 14 | |
| 5 | 10 | 10.0% |
| 11 | 8 | 8.0% |
| 10 | 8 | 8.0% |
| 9 | 5 | 5.0% |
| 12 | 4 | 4.0% |
| 13 | 3 | 3.0% |
| 4 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 4 | 1 | 1.0% |
| 5 | 10 | 10.0% |
| 6 | 29 | |
| 7 | 17 | |
| 8 | 14 | |
| 9 | 5 | 5.0% |
| 10 | 8 | 8.0% |
| 11 | 8 | 8.0% |
| 12 | 4 | 4.0% |
| 13 | 3 | 3.0% |
| Value | Count | Frequency (%) |
| 14 | 1 | 1.0% |
| 13 | 3 | 3.0% |
| 12 | 4 | 4.0% |
| 11 | 8 | 8.0% |
| 10 | 8 | 8.0% |
| 9 | 5 | 5.0% |
| 8 | 14 | |
| 7 | 17 | |
| 6 | 29 | |
| 5 | 10 | 10.0% |
BUN/Cr_DATE
Date
| Distinct | 90 |
|---|---|
| Distinct (%) | 90.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.0 B |
| Minimum | 2015-10-01 00:00:00 |
|---|---|
| Maximum | 2020-01-13 00:00:00 |
Histogram with fixed size bins (bins=50)
BUN_VAL
Real number (ℝ)
HIGH CORRELATION
| Distinct | 81 |
|---|---|
| Distinct (%) | 81.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.545 |
| Minimum | 8.5 |
|---|---|
| Maximum | 121.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 8.5 |
|---|---|
| 5-th percentile | 9.895 |
| Q1 | 12.3 |
| median | 15.35 |
| Q3 | 21.425 |
| 95-th percentile | 33.225 |
| Maximum | 121.6 |
| Range | 113.1 |
| Interquartile range (IQR) | 9.125 |
Descriptive statistics
| Standard deviation | 12.687155 |
|---|---|
| Coefficient of variation (CV) | 0.68412809 |
| Kurtosis | 44.063619 |
| Mean | 18.545 |
| Median Absolute Deviation (MAD) | 3.65 |
| Skewness | 5.69677 |
| Sum | 1854.5 |
| Variance | 160.96391 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13.2 | 3 | 3.0% |
| 15.3 | 2 | 2.0% |
| 18.6 | 2 | 2.0% |
| 15.8 | 2 | 2.0% |
| 13.3 | 2 | 2.0% |
| 9.0 | 2 | 2.0% |
| 16.6 | 2 | 2.0% |
| 11.4 | 2 | 2.0% |
| 14.0 | 2 | 2.0% |
| 11.2 | 2 | 2.0% |
| Other values (71) | 79 |
| Value | Count | Frequency (%) |
| 8.5 | 1 | |
| 9.0 | 2 | |
| 9.1 | 1 | |
| 9.8 | 1 | |
| 9.9 | 2 | |
| 10.0 | 1 | |
| 10.2 | 1 | |
| 10.3 | 1 | |
| 10.4 | 1 | |
| 10.5 | 1 |
| Value | Count | Frequency (%) |
| 121.6 | 1 | |
| 44.4 | 1 | |
| 36.8 | 1 | |
| 36.7 | 1 | |
| 35.6 | 1 | |
| 33.1 | 1 | |
| 32.0 | 1 | |
| 30.6 | 1 | |
| 30.3 | 1 | |
| 29.4 | 1 |
Cr_VAL
Real number (ℝ)
HIGH CORRELATION
| Distinct | 60 |
|---|---|
| Distinct (%) | 60.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0899 |
| Minimum | 0.41 |
|---|---|
| Maximum | 9.07 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 0.41 |
|---|---|
| 5-th percentile | 0.5 |
| Q1 | 0.6375 |
| median | 0.86 |
| Q3 | 1.015 |
| 95-th percentile | 2.519 |
| Maximum | 9.07 |
| Range | 8.66 |
| Interquartile range (IQR) | 0.3775 |
Descriptive statistics
| Standard deviation | 1.1997176 |
|---|---|
| Coefficient of variation (CV) | 1.1007593 |
| Kurtosis | 32.372028 |
| Mean | 1.0899 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | 5.4222516 |
| Sum | 108.99 |
| Variance | 1.4393222 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.58 | 4 | 4.0% |
| 0.96 | 4 | 4.0% |
| 0.95 | 3 | 3.0% |
| 0.97 | 3 | 3.0% |
| 0.63 | 3 | 3.0% |
| 1.08 | 3 | 3.0% |
| 0.89 | 3 | 3.0% |
| 0.91 | 3 | 3.0% |
| 0.72 | 3 | 3.0% |
| 0.61 | 3 | 3.0% |
| Other values (50) | 68 |
| Value | Count | Frequency (%) |
| 0.41 | 1 | |
| 0.47 | 1 | |
| 0.48 | 1 | |
| 0.49 | 1 | |
| 0.5 | 2 | |
| 0.51 | 1 | |
| 0.52 | 1 | |
| 0.53 | 2 | |
| 0.54 | 1 | |
| 0.56 | 2 |
| Value | Count | Frequency (%) |
| 9.07 | 1 | |
| 8.32 | 1 | |
| 3.55 | 1 | |
| 2.69 | 2 | |
| 2.51 | 1 | |
| 2.11 | 1 | |
| 1.73 | 1 | |
| 1.58 | 1 | |
| 1.56 | 1 | |
| 1.4 | 1 |
AST_VAL
Real number (ℝ)
HIGH CORRELATION
| Distinct | 39 |
|---|---|
| Distinct (%) | 39.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.23 |
| Minimum | 12 |
|---|---|
| Maximum | 564 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 12 |
|---|---|
| 5-th percentile | 13.95 |
| Q1 | 18 |
| median | 23.5 |
| Q3 | 32 |
| 95-th percentile | 71.2 |
| Maximum | 564 |
| Range | 552 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 55.854221 |
|---|---|
| Coefficient of variation (CV) | 1.6808372 |
| Kurtosis | 84.451955 |
| Mean | 33.23 |
| Median Absolute Deviation (MAD) | 6.5 |
| Skewness | 8.8633626 |
| Sum | 3323 |
| Variance | 3119.694 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=39)
| Value | Count | Frequency (%) |
| 20 | 8 | 8.0% |
| 15 | 8 | 8.0% |
| 25 | 7 | 7.0% |
| 19 | 5 | 5.0% |
| 16 | 4 | 4.0% |
| 21 | 4 | 4.0% |
| 28 | 4 | 4.0% |
| 17 | 4 | 4.0% |
| 24 | 4 | 4.0% |
| 18 | 4 | 4.0% |
| Other values (29) | 48 |
| Value | Count | Frequency (%) |
| 12 | 3 | 3.0% |
| 13 | 2 | 2.0% |
| 14 | 2 | 2.0% |
| 15 | 8 | |
| 16 | 4 | |
| 17 | 4 | |
| 18 | 4 | |
| 19 | 5 | |
| 20 | 8 | |
| 21 | 4 |
| Value | Count | Frequency (%) |
| 564 | 1 | 1.0% |
| 86 | 1 | 1.0% |
| 75 | 3 | |
| 71 | 2 | |
| 61 | 1 | 1.0% |
| 57 | 1 | 1.0% |
| 55 | 1 | 1.0% |
| 52 | 1 | 1.0% |
| 47 | 1 | 1.0% |
| 43 | 1 | 1.0% |
ALT_VAL
Real number (ℝ)
HIGH CORRELATION
| Distinct | 43 |
|---|---|
| Distinct (%) | 43.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.05 |
| Minimum | 6 |
|---|---|
| Maximum | 375 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 18 |
| median | 24 |
| Q3 | 33.25 |
| 95-th percentile | 62.05 |
| Maximum | 375 |
| Range | 369 |
| Interquartile range (IQR) | 15.25 |
Descriptive statistics
| Standard deviation | 38.244924 |
|---|---|
| Coefficient of variation (CV) | 1.1932894 |
| Kurtosis | 66.452631 |
| Mean | 32.05 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 7.4983024 |
| Sum | 3205 |
| Variance | 1462.6742 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) |
| 21 | 9 | 9.0% |
| 24 | 7 | 7.0% |
| 15 | 5 | 5.0% |
| 18 | 5 | 5.0% |
| 13 | 5 | 5.0% |
| 19 | 4 | 4.0% |
| 31 | 4 | 4.0% |
| 26 | 4 | 4.0% |
| 29 | 3 | 3.0% |
| 53 | 3 | 3.0% |
| Other values (33) | 51 |
| Value | Count | Frequency (%) |
| 6 | 1 | 1.0% |
| 10 | 2 | 2.0% |
| 11 | 1 | 1.0% |
| 12 | 2 | 2.0% |
| 13 | 5 | |
| 14 | 3 | |
| 15 | 5 | |
| 16 | 2 | 2.0% |
| 17 | 2 | 2.0% |
| 18 | 5 |
| Value | Count | Frequency (%) |
| 375 | 1 | 1.0% |
| 98 | 1 | 1.0% |
| 68 | 1 | 1.0% |
| 63 | 2 | |
| 62 | 1 | 1.0% |
| 61 | 2 | |
| 59 | 1 | 1.0% |
| 57 | 1 | 1.0% |
| 55 | 1 | 1.0% |
| 53 | 3 |
MDRD_VAL
Real number (ℝ)
HIGH CORRELATION UNIQUE
| Distinct | 100 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 85.3065 |
| Minimum | 4.71 |
|---|---|
| Maximum | 178.66 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 4.71 |
|---|---|
| 5-th percentile | 23.069 |
| Q1 | 64.0475 |
| median | 86.025 |
| Q3 | 107.4 |
| 95-th percentile | 138.0005 |
| Maximum | 178.66 |
| Range | 173.95 |
| Interquartile range (IQR) | 43.3525 |
Descriptive statistics
| Standard deviation | 34.029447 |
|---|---|
| Coefficient of variation (CV) | 0.39890802 |
| Kurtosis | 0.40231017 |
| Mean | 85.3065 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | 0.034029896 |
| Sum | 8530.65 |
| Variance | 1158.0033 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 50.4 | 1 | 1.0% |
| 80.06 | 1 | 1.0% |
| 32.18 | 1 | 1.0% |
| 64.07 | 1 | 1.0% |
| 81.32 | 1 | 1.0% |
| 104.01 | 1 | 1.0% |
| 95.31 | 1 | 1.0% |
| 60.27 | 1 | 1.0% |
| 108.09 | 1 | 1.0% |
| 96.82 | 1 | 1.0% |
| Other values (90) | 90 |
| Value | Count | Frequency (%) |
| 4.71 | 1 | |
| 5.11 | 1 | |
| 16.88 | 1 | |
| 19.55 | 1 | |
| 22.67 | 1 | |
| 23.09 | 1 | |
| 24.5 | 1 | |
| 32.18 | 1 | |
| 37.55 | 1 | |
| 37.68 | 1 |
| Value | Count | Frequency (%) |
| 178.66 | 1 | |
| 176.02 | 1 | |
| 156.46 | 1 | |
| 148.95 | 1 | |
| 141.05 | 1 | |
| 137.84 | 1 | |
| 134.66 | 1 | |
| 132.17 | 1 | |
| 129.02 | 1 | |
| 127.63 | 1 |
| Distinct | 92 |
|---|---|
| Distinct (%) | 92.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.0 B |
| Minimum | 2015-10-01 00:00:00 |
|---|---|
| Maximum | 2020-01-13 00:00:00 |
Histogram with fixed size bins (bins=50)
TC_VAL
Real number (ℝ)
HIGH CORRELATION
| Distinct | 77 |
|---|---|
| Distinct (%) | 77.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 171.59 |
| Minimum | 79 |
|---|---|
| Maximum | 329 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 79 |
|---|---|
| 5-th percentile | 100.9 |
| Q1 | 133 |
| median | 166 |
| Q3 | 201.25 |
| 95-th percentile | 274.15 |
| Maximum | 329 |
| Range | 250 |
| Interquartile range (IQR) | 68.25 |
Descriptive statistics
| Standard deviation | 52.636373 |
|---|---|
| Coefficient of variation (CV) | 0.30675665 |
| Kurtosis | 0.27251903 |
| Mean | 171.59 |
| Median Absolute Deviation (MAD) | 34 |
| Skewness | 0.70108426 |
| Sum | 17159 |
| Variance | 2770.5878 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 159 | 3 | 3.0% |
| 178 | 3 | 3.0% |
| 166 | 3 | 3.0% |
| 154 | 3 | 3.0% |
| 189 | 2 | 2.0% |
| 195 | 2 | 2.0% |
| 124 | 2 | 2.0% |
| 114 | 2 | 2.0% |
| 115 | 2 | 2.0% |
| 230 | 2 | 2.0% |
| Other values (67) | 76 |
| Value | Count | Frequency (%) |
| 79 | 1 | |
| 84 | 1 | |
| 93 | 1 | |
| 95 | 1 | |
| 99 | 1 | |
| 101 | 1 | |
| 103 | 1 | |
| 104 | 1 | |
| 108 | 2 | |
| 110 | 1 |
| Value | Count | Frequency (%) |
| 329 | 1 | |
| 304 | 1 | |
| 296 | 1 | |
| 291 | 1 | |
| 277 | 1 | |
| 274 | 1 | |
| 265 | 1 | |
| 260 | 1 | |
| 255 | 1 | |
| 244 | 1 |
TG_VAL
Real number (ℝ)
| Distinct | 81 |
|---|---|
| Distinct (%) | 81.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 167.75 |
| Minimum | 49 |
|---|---|
| Maximum | 839 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 49 |
|---|---|
| 5-th percentile | 58.9 |
| Q1 | 87.25 |
| median | 117 |
| Q3 | 178.25 |
| 95-th percentile | 611.6 |
| Maximum | 839 |
| Range | 790 |
| Interquartile range (IQR) | 91 |
Descriptive statistics
| Standard deviation | 155.77868 |
|---|---|
| Coefficient of variation (CV) | 0.92863595 |
| Kurtosis | 9.3780936 |
| Mean | 167.75 |
| Median Absolute Deviation (MAD) | 41.5 |
| Skewness | 3.0405561 |
| Sum | 16775 |
| Variance | 24266.997 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 78 | 3 | 3.0% |
| 76 | 3 | 3.0% |
| 95 | 2 | 2.0% |
| 55 | 2 | 2.0% |
| 74 | 2 | 2.0% |
| 100 | 2 | 2.0% |
| 81 | 2 | 2.0% |
| 104 | 2 | 2.0% |
| 136 | 2 | 2.0% |
| 191 | 2 | 2.0% |
| Other values (71) | 78 |
| Value | Count | Frequency (%) |
| 49 | 1 | |
| 50 | 1 | |
| 55 | 2 | |
| 57 | 1 | |
| 59 | 2 | |
| 62 | 1 | |
| 68 | 1 | |
| 71 | 2 | |
| 72 | 1 | |
| 74 | 2 |
| Value | Count | Frequency (%) |
| 839 | 1 | |
| 829 | 1 | |
| 752 | 1 | |
| 686 | 1 | |
| 661 | 1 | |
| 609 | 1 | |
| 328 | 1 | |
| 295 | 1 | |
| 287 | 1 | |
| 265 | 1 |
HDL_VAL
Real number (ℝ)
| Distinct | 40 |
|---|---|
| Distinct (%) | 40.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.3 |
| Minimum | 9 |
|---|---|
| Maximum | 87 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 26.95 |
| Q1 | 36 |
| median | 45.5 |
| Q3 | 52 |
| 95-th percentile | 59.1 |
| Maximum | 87 |
| Range | 78 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 11.960795 |
|---|---|
| Coefficient of variation (CV) | 0.26999536 |
| Kurtosis | 1.4807985 |
| Mean | 44.3 |
| Median Absolute Deviation (MAD) | 6.5 |
| Skewness | 0.1818692 |
| Sum | 4430 |
| Variance | 143.06061 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=40)
| Value | Count | Frequency (%) |
| 52 | 9 | 9.0% |
| 47 | 7 | 7.0% |
| 50 | 6 | 6.0% |
| 36 | 6 | 6.0% |
| 51 | 5 | 5.0% |
| 44 | 4 | 4.0% |
| 39 | 4 | 4.0% |
| 49 | 4 | 4.0% |
| 43 | 4 | 4.0% |
| 57 | 3 | 3.0% |
| Other values (30) | 48 |
| Value | Count | Frequency (%) |
| 9 | 1 | 1.0% |
| 15 | 1 | 1.0% |
| 25 | 2 | |
| 26 | 1 | 1.0% |
| 27 | 2 | |
| 28 | 3 | |
| 29 | 2 | |
| 31 | 2 | |
| 32 | 2 | |
| 33 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 87 | 1 | 1.0% |
| 74 | 1 | 1.0% |
| 71 | 1 | 1.0% |
| 68 | 1 | 1.0% |
| 61 | 1 | 1.0% |
| 59 | 1 | 1.0% |
| 58 | 3 | |
| 57 | 3 | |
| 56 | 1 | 1.0% |
| 54 | 2 |
LDL_VAL
Real number (ℝ)
HIGH CORRELATION
| Distinct | 73 |
|---|---|
| Distinct (%) | 73.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 96.14 |
| Minimum | 34 |
|---|---|
| Maximum | 214 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 34 |
|---|---|
| 5-th percentile | 41.95 |
| Q1 | 69 |
| median | 88 |
| Q3 | 117.25 |
| 95-th percentile | 166.4 |
| Maximum | 214 |
| Range | 180 |
| Interquartile range (IQR) | 48.25 |
Descriptive statistics
| Standard deviation | 39.180241 |
|---|---|
| Coefficient of variation (CV) | 0.40753319 |
| Kurtosis | 0.21793721 |
| Mean | 96.14 |
| Median Absolute Deviation (MAD) | 23.5 |
| Skewness | 0.72141491 |
| Sum | 9614 |
| Variance | 1535.0913 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 80 | 4 | 4.0% |
| 102 | 3 | 3.0% |
| 107 | 3 | 3.0% |
| 81 | 3 | 3.0% |
| 69 | 3 | 3.0% |
| 104 | 3 | 3.0% |
| 163 | 2 | 2.0% |
| 79 | 2 | 2.0% |
| 95 | 2 | 2.0% |
| 86 | 2 | 2.0% |
| Other values (63) | 73 |
| Value | Count | Frequency (%) |
| 34 | 2 | |
| 37 | 1 | |
| 38 | 1 | |
| 41 | 1 | |
| 42 | 1 | |
| 44 | 2 | |
| 45 | 1 | |
| 47 | 1 | |
| 48 | 2 | |
| 51 | 1 |
| Value | Count | Frequency (%) |
| 214 | 1 | |
| 194 | 1 | |
| 193 | 1 | |
| 180 | 1 | |
| 174 | 1 | |
| 166 | 1 | |
| 163 | 2 | |
| 154 | 1 | |
| 153 | 1 | |
| 152 | 1 |
| RID | A1C_DATE | A1C_VAL | A1C_VAL_C | BUN/Cr_DATE | BUN_VAL | Cr_VAL | AST_VAL | ALT_VAL | MDRD_VAL | TC/TG/HDL/LDL_DATE | TC_VAL | TG_VAL | HDL_VAL | LDL_VAL | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RID | 1.000 | 0.893 | 0.235 | 0.346 | 0.834 | 0.378 | 0.151 | 0.000 | 0.179 | 0.000 | 0.922 | 0.000 | 0.203 | 0.000 | 0.000 |
| A1C_DATE | 0.893 | 1.000 | 0.954 | 0.950 | 0.999 | 0.730 | 0.930 | 0.886 | 0.972 | 0.926 | 0.997 | 0.862 | 0.975 | 0.000 | 0.778 |
| A1C_VAL | 0.235 | 0.954 | 1.000 | 0.976 | 0.958 | 0.244 | 0.302 | 0.000 | 0.000 | 0.311 | 0.896 | 0.262 | 0.000 | 0.099 | 0.421 |
| A1C_VAL_C | 0.346 | 0.950 | 0.976 | 1.000 | 0.965 | 0.271 | 0.561 | 0.000 | 0.299 | 0.199 | 0.909 | 0.000 | 0.000 | 0.000 | 0.326 |
| BUN/Cr_DATE | 0.834 | 0.999 | 0.958 | 0.965 | 1.000 | 0.941 | 0.987 | 0.944 | 0.967 | 0.911 | 0.998 | 0.878 | 0.839 | 0.369 | 0.861 |
| BUN_VAL | 0.378 | 0.730 | 0.244 | 0.271 | 0.941 | 1.000 | 0.945 | 0.000 | 0.000 | 0.774 | 0.905 | 0.204 | 0.000 | 0.499 | 0.000 |
| Cr_VAL | 0.151 | 0.930 | 0.302 | 0.561 | 0.987 | 0.945 | 1.000 | 0.000 | 0.000 | 0.893 | 0.944 | 0.604 | 0.000 | 0.476 | 0.000 |
| AST_VAL | 0.000 | 0.886 | 0.000 | 0.000 | 0.944 | 0.000 | 0.000 | 1.000 | 0.743 | 0.143 | 0.902 | 0.000 | 0.155 | 0.000 | 0.000 |
| ALT_VAL | 0.179 | 0.972 | 0.000 | 0.299 | 0.967 | 0.000 | 0.000 | 0.743 | 1.000 | 0.075 | 0.924 | 0.000 | 0.000 | 0.000 | 0.000 |
| MDRD_VAL | 0.000 | 0.926 | 0.311 | 0.199 | 0.911 | 0.774 | 0.893 | 0.143 | 0.075 | 1.000 | 0.880 | 0.371 | 0.000 | 0.545 | 0.000 |
| TC/TG/HDL/LDL_DATE | 0.922 | 0.997 | 0.896 | 0.909 | 0.998 | 0.905 | 0.944 | 0.902 | 0.924 | 0.880 | 1.000 | 0.826 | 0.720 | 0.929 | 0.835 |
| TC_VAL | 0.000 | 0.862 | 0.262 | 0.000 | 0.878 | 0.204 | 0.604 | 0.000 | 0.000 | 0.371 | 0.826 | 1.000 | 0.594 | 0.396 | 0.901 |
| TG_VAL | 0.203 | 0.975 | 0.000 | 0.000 | 0.839 | 0.000 | 0.000 | 0.155 | 0.000 | 0.000 | 0.720 | 0.594 | 1.000 | 0.000 | 0.000 |
| HDL_VAL | 0.000 | 0.000 | 0.099 | 0.000 | 0.369 | 0.499 | 0.476 | 0.000 | 0.000 | 0.545 | 0.929 | 0.396 | 0.000 | 1.000 | 0.000 |
| LDL_VAL | 0.000 | 0.778 | 0.421 | 0.326 | 0.861 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.835 | 0.901 | 0.000 | 0.000 | 1.000 |
| RID | A1C_VAL | A1C_VAL_C | BUN_VAL | Cr_VAL | AST_VAL | ALT_VAL | MDRD_VAL | TC_VAL | TG_VAL | HDL_VAL | LDL_VAL | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RID | 1.000 | -0.076 | -0.057 | 0.010 | -0.144 | -0.023 | -0.055 | 0.033 | -0.060 | -0.069 | 0.056 | -0.018 |
| A1C_VAL | -0.076 | 1.000 | 0.983 | -0.019 | 0.091 | -0.226 | 0.153 | 0.088 | 0.046 | 0.119 | -0.229 | 0.083 |
| A1C_VAL_C | -0.057 | 0.983 | 1.000 | 0.016 | 0.074 | -0.244 | 0.147 | 0.089 | 0.054 | 0.111 | -0.216 | 0.092 |
| BUN_VAL | 0.010 | -0.019 | 0.016 | 1.000 | 0.674 | -0.017 | -0.129 | -0.689 | -0.214 | -0.069 | -0.221 | -0.119 |
| Cr_VAL | -0.144 | 0.091 | 0.074 | 0.674 | 1.000 | -0.025 | -0.049 | -0.903 | -0.155 | 0.209 | -0.443 | -0.045 |
| AST_VAL | -0.023 | -0.226 | -0.244 | -0.017 | -0.025 | 1.000 | 0.645 | -0.024 | -0.075 | 0.015 | 0.094 | -0.076 |
| ALT_VAL | -0.055 | 0.153 | 0.147 | -0.129 | -0.049 | 0.645 | 1.000 | 0.153 | -0.027 | 0.138 | -0.032 | -0.080 |
| MDRD_VAL | 0.033 | 0.088 | 0.089 | -0.689 | -0.903 | -0.024 | 0.153 | 1.000 | 0.244 | -0.138 | 0.378 | 0.151 |
| TC_VAL | -0.060 | 0.046 | 0.054 | -0.214 | -0.155 | -0.075 | -0.027 | 0.244 | 1.000 | 0.398 | 0.360 | 0.875 |
| TG_VAL | -0.069 | 0.119 | 0.111 | -0.069 | 0.209 | 0.015 | 0.138 | -0.138 | 0.398 | 1.000 | -0.189 | 0.212 |
| HDL_VAL | 0.056 | -0.229 | -0.216 | -0.221 | -0.443 | 0.094 | -0.032 | 0.378 | 0.360 | -0.189 | 1.000 | 0.228 |
| LDL_VAL | -0.018 | 0.083 | 0.092 | -0.119 | -0.045 | -0.076 | -0.080 | 0.151 | 0.875 | 0.212 | 0.228 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| RID | A1C_DATE | A1C_VAL | A1C_VAL_C | BUN/Cr_DATE | BUN_VAL | Cr_VAL | AST_VAL | ALT_VAL | MDRD_VAL | TC/TG/HDL/LDL_DATE | TC_VAL | TG_VAL | HDL_VAL | LDL_VAL | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 2019-08-19 | 5.7 | 5 | 2019-08-19 | 29.4 | 1.4 | 23 | 11 | 50.4 | 2019-08-19 | 103 | 234 | 28 | 34 |
| 1 | 2 | 2019-07-23 | 6.5 | 6 | 2019-07-23 | 12.0 | 0.56 | 24 | 13 | 107.02 | 2019-07-23 | 143 | 59 | 50 | 73 |
| 2 | 3 | 2017-10-11 | 6.7 | 6 | 2017-10-31 | 12.7 | 0.87 | 21 | 27 | 89.51 | 2017-10-13 | 111 | 127 | 53 | 34 |
| 3 | 4 | 2017-04-17 | 6.5 | 6 | 2017-04-14 | 9.1 | 0.75 | 71 | 44 | 77.8 | 2017-04-17 | 162 | 103 | 47 | 97 |
| 4 | 5 | 2019-04-16 | 4.7 | 4 | 2019-04-16 | 30.3 | 2.51 | 25 | 18 | 19.55 | 2019-04-16 | 175 | 125 | 51 | 87 |
| 5 | 6 | 2019-06-20 | 9.9 | 9 | 2019-06-20 | 22.9 | 1.03 | 32 | 22 | 74.17 | 2019-06-20 | 133 | 109 | 34 | 81 |
| 6 | 7 | 2019-05-29 | 6.4 | 6 | 2019-05-29 | 11.6 | 0.49 | 17 | 21 | 137.84 | 2019-05-29 | 194 | 96 | 71 | 100 |
| 7 | 8 | 2018-10-02 | 9.2 | 9 | 2018-10-02 | 10.2 | 0.72 | 25 | 29 | 108.24 | 2018-10-02 | 178 | 116 | 49 | 116 |
| 8 | 9 | 2019-10-18 | 8.0 | 8 | 2019-10-18 | 21.6 | 0.95 | 22 | 24 | 77.71 | 2019-10-18 | 141 | 91 | 52 | 72 |
| 9 | 10 | 2018-11-08 | 6.3 | 6 | 2018-11-08 | 36.7 | 2.69 | 17 | 10 | 22.67 | 2018-11-08 | 166 | 98 | 27 | 124 |
| RID | A1C_DATE | A1C_VAL | A1C_VAL_C | BUN/Cr_DATE | BUN_VAL | Cr_VAL | AST_VAL | ALT_VAL | MDRD_VAL | TC/TG/HDL/LDL_DATE | TC_VAL | TG_VAL | HDL_VAL | LDL_VAL | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90 | 91 | 2019-06-21 | 5.8 | 5 | 2019-06-21 | 24.5 | 1.08 | 19 | 15 | 72.67 | 2019-06-21 | 202 | 201 | 47 | 126 |
| 91 | 92 | 2019-06-13 | 6.7 | 6 | 2019-06-13 | 10.0 | 0.5 | 57 | 53 | 127.63 | 2019-06-13 | 159 | 104 | 52 | 79 |
| 92 | 93 | 2016-06-27 | 10.0 | 10 | 2016-06-27 | 20.1 | 0.96 | 15 | 13 | 77.44 | 2016-06-27 | 236 | 175 | 52 | 152 |
| 93 | 94 | 2019-05-22 | 8.8 | 8 | 2019-05-22 | 12.6 | 0.41 | 24 | 21 | 178.66 | 2019-05-22 | 155 | 191 | 48 | 82 |
| 94 | 95 | 2018-07-18 | 11.7 | 11 | 2018-07-18 | 9.8 | 0.85 | 23 | 36 | 97.92 | 2018-07-18 | 195 | 178 | 47 | 117 |
| 95 | 96 | 2019-10-28 | 11.0 | 11 | 2019-10-28 | 13.2 | 0.58 | 21 | 26 | 114.01 | 2019-10-28 | 304 | 167 | 58 | 214 |
| 96 | 97 | 2019-07-26 | 6.3 | 6 | 2019-06-27 | 13.8 | 0.81 | 27 | 23 | 68.56 | 2019-07-26 | 95 | 114 | 32 | 45 |
| 97 | 98 | 2019-10-16 | 6.3 | 6 | 2019-10-16 | 14.8 | 0.73 | 29 | 16 | 79.52 | 2019-10-16 | 274 | 76 | 87 | 149 |
| 98 | 99 | 2018-06-01 | 11.9 | 11 | 2018-06-01 | 10.4 | 0.92 | 14 | 13 | 59.84 | 2018-06-02 | 93 | 76 | 36 | 37 |
| 99 | 100 | 2019-07-29 | 7.5 | 7 | 2019-07-29 | 13.8 | 0.51 | 24 | 24 | 120.65 | 2019-07-29 | 156 | 115 | 57 | 44 |