Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 100 |
| Missing cells | 417 |
| Missing cells (%) | 37.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 9.8 KiB |
| Average record size in memory | 100.3 B |
Variable types
| Numeric | 11 |
|---|
Dataset
| Description | 알코올 사용 장애 환자들의 스타틴 처방 데이터와 스타틴 처방 이전이나 이후에 처방된 선행 약물과 병용 약물 현황을 분석할 수 있는 데이터. 주요 처방 약물에는 가장 많이 처방되는 Acamprosate와 경구 Lorazepam, Naltrexone등이 포함됨. 이외에 수면제인 Zolpidem과 항우울제인 Mirtazapine 처방 정보가 포함됨. 약물 처방 데이터는 1일 기준 용량과 수량, 처방횟수, 처방 일수 데이터를 이용하여 총 투여량을 생성할 수 있음. 약물 처방 데이터는 RxNorm 코드로 매핑됨 |
|---|---|
| Author | 가톨릭대학교 은평성모병원 |
| URL | http://cmcdata.net/data/dataset/administration-drug-data-alcohol-use-disorder-eunpyeong |
_ID is highly overall correlated with RID | High correlation |
RID is highly overall correlated with _ID | High correlation |
ACAMPROSTATE_SCT is highly overall correlated with ACAMPROSTATE_LST and 4 other fields | High correlation |
ACAMPROSTATE_LST is highly overall correlated with ACAMPROSTATE_SCT and 4 other fields | High correlation |
NALTREXONE_SCT is highly overall correlated with ACAMPROSTATE_SCT and 5 other fields | High correlation |
NALTREXONE_LST is highly overall correlated with ACAMPROSTATE_SCT and 4 other fields | High correlation |
NALTREXONE_VALUE is highly overall correlated with LORAZEPAM_LCT | High correlation |
LORAZEPAM_SCT is highly overall correlated with ACAMPROSTATE_SCT and 4 other fields | High correlation |
LORAZEPAM_LCT is highly overall correlated with ACAMPROSTATE_SCT and 4 other fields | High correlation |
LORAZEPAM_VALUE is highly overall correlated with NALTREXONE_SCT and 1 other fields | High correlation |
NALTREXONE_SCT has 60 (60.0%) missing values | Missing |
NALTREXONE_LST has 60 (60.0%) missing values | Missing |
NALTREXONE_VALUE has 60 (60.0%) missing values | Missing |
LORAZEPAM_SCT has 79 (79.0%) missing values | Missing |
LORAZEPAM_LCT has 79 (79.0%) missing values | Missing |
LORAZEPAM_VALUE has 79 (79.0%) missing values | Missing |
_ID has unique values | Unique |
RID has unique values | Unique |
Reproduction
| Analysis started | 2023-10-08 18:56:30.992376 |
|---|---|
| Analysis finished | 2023-10-08 18:57:00.392617 |
| Duration | 29.4 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
_ID
Real number (ℝ)
HIGH CORRELATION 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 |
RID
Real number (ℝ)
HIGH CORRELATION 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 |
ACAMPROSTATE_SCT
Real number (ℝ)
HIGH CORRELATION
| Distinct | 92 |
|---|---|
| Distinct (%) | 92.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20178700 |
| Minimum | 20150909 |
|---|---|
| Maximum | 20200407 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 20150909 |
|---|---|
| 5-th percentile | 20150924 |
| Q1 | 20170225 |
| median | 20180956 |
| Q3 | 20190810 |
| 95-th percentile | 20200210 |
| Maximum | 20200407 |
| Range | 49498 |
| Interquartile range (IQR) | 20584.75 |
Descriptive statistics
| Standard deviation | 15452.566 |
|---|---|
| Coefficient of variation (CV) | 0.000765786 |
| Kurtosis | -0.93092042 |
| Mean | 20178700 |
| Median Absolute Deviation (MAD) | 10144.5 |
| Skewness | -0.48203013 |
| Sum | 2.01787 × 109 |
| Variance | 2.3878179 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20150924 | 3 | 3.0% |
| 20190424 | 2 | 2.0% |
| 20190412 | 2 | 2.0% |
| 20190726 | 2 | 2.0% |
| 20190812 | 2 | 2.0% |
| 20170908 | 2 | 2.0% |
| 20170801 | 2 | 2.0% |
| 20190807 | 1 | 1.0% |
| 20200216 | 1 | 1.0% |
| 20190202 | 1 | 1.0% |
| Other values (82) | 82 |
| Value | Count | Frequency (%) |
| 20150909 | 1 | 1.0% |
| 20150915 | 1 | 1.0% |
| 20150917 | 1 | 1.0% |
| 20150924 | 3 | |
| 20150925 | 1 | 1.0% |
| 20151001 | 1 | 1.0% |
| 20151013 | 1 | 1.0% |
| 20151026 | 1 | 1.0% |
| 20151028 | 1 | 1.0% |
| 20151029 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 20200407 | 1 | |
| 20200402 | 1 | |
| 20200324 | 1 | |
| 20200219 | 1 | |
| 20200216 | 1 | |
| 20200210 | 1 | |
| 20200204 | 1 | |
| 20200130 | 1 | |
| 20200121 | 1 | |
| 20200103 | 1 |
ACAMPROSTATE_LST
Real number (ℝ)
HIGH CORRELATION
| Distinct | 95 |
|---|---|
| Distinct (%) | 95.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20182812 |
| Minimum | 20151001 |
|---|---|
| Maximum | 20200427 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 20151001 |
|---|---|
| 5-th percentile | 20151224 |
| Q1 | 20170712 |
| median | 20190304 |
| Q3 | 20191121 |
| 95-th percentile | 20200407 |
| Maximum | 20200427 |
| Range | 49426 |
| Interquartile range (IQR) | 20409 |
Descriptive statistics
| Standard deviation | 14963.249 |
|---|---|
| Coefficient of variation (CV) | 0.00074138576 |
| Kurtosis | -0.73300597 |
| Mean | 20182812 |
| Median Absolute Deviation (MAD) | 9959.5 |
| Skewness | -0.62545073 |
| Sum | 2.0182812 × 109 |
| Variance | 2.2389882 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20170801 | 2 | 2.0% |
| 20200407 | 2 | 2.0% |
| 20191202 | 2 | 2.0% |
| 20170914 | 2 | 2.0% |
| 20190812 | 2 | 2.0% |
| 20171208 | 1 | 1.0% |
| 20190919 | 1 | 1.0% |
| 20190807 | 1 | 1.0% |
| 20200327 | 1 | 1.0% |
| 20151230 | 1 | 1.0% |
| Other values (85) | 85 |
| Value | Count | Frequency (%) |
| 20151001 | 1 | |
| 20151002 | 1 | |
| 20151013 | 1 | |
| 20151026 | 1 | |
| 20151110 | 1 | |
| 20151230 | 1 | |
| 20160106 | 1 | |
| 20160115 | 1 | |
| 20160205 | 1 | |
| 20160331 | 1 |
| Value | Count | Frequency (%) |
| 20200427 | 1 | |
| 20200420 | 1 | |
| 20200417 | 1 | |
| 20200410 | 1 | |
| 20200407 | 2 | |
| 20200403 | 1 | |
| 20200402 | 1 | |
| 20200327 | 1 | |
| 20200326 | 1 | |
| 20200324 | 1 |
ACAMPROSTATE_VALUE
Real number (ℝ)
| Distinct | 43 |
|---|---|
| Distinct (%) | 43.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4149.746 |
| Minimum | 333 |
|---|---|
| Maximum | 11988 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 333 |
|---|---|
| 5-th percentile | 573.92 |
| Q1 | 1332 |
| median | 2997 |
| Q3 | 5328 |
| 95-th percentile | 11988 |
| Maximum | 11988 |
| Range | 11655 |
| Interquartile range (IQR) | 3996 |
Descriptive statistics
| Standard deviation | 3480.376 |
|---|---|
| Coefficient of variation (CV) | 0.83869615 |
| Kurtosis | 0.37472037 |
| Mean | 4149.746 |
| Median Absolute Deviation (MAD) | 1718.6 |
| Skewness | 1.1803324 |
| Sum | 414974.6 |
| Variance | 12113017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) |
| 1332.0 | 17 | |
| 2997.0 | 16 | |
| 5328.0 | 15 | |
| 11988.0 | 9 | 9.0% |
| 333.0 | 5 | 5.0% |
| 2484.7 | 1 | 1.0% |
| 4098.5 | 1 | 1.0% |
| 999.0 | 1 | 1.0% |
| 2655.2 | 1 | 1.0% |
| 2619.6 | 1 | 1.0% |
| Other values (33) | 33 |
| Value | Count | Frequency (%) |
| 333.0 | 5 | 5.0% |
| 586.6 | 1 | 1.0% |
| 640.4 | 1 | 1.0% |
| 747.5 | 1 | 1.0% |
| 777.0 | 1 | 1.0% |
| 903.9 | 1 | 1.0% |
| 993.6 | 1 | 1.0% |
| 999.0 | 1 | 1.0% |
| 1224.8 | 1 | 1.0% |
| 1332.0 | 17 |
| Value | Count | Frequency (%) |
| 11988.0 | 9 | |
| 11452.1 | 1 | 1.0% |
| 10989.0 | 1 | 1.0% |
| 10903.2 | 1 | 1.0% |
| 10489.5 | 1 | 1.0% |
| 9768.0 | 1 | 1.0% |
| 7492.5 | 1 | 1.0% |
| 7192.8 | 1 | 1.0% |
| 6738.2 | 1 | 1.0% |
| 6406.3 | 1 | 1.0% |
NALTREXONE_SCT
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 37 |
|---|---|
| Distinct (%) | 92.5% |
| Missing | 60 |
| Missing (%) | 60.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20178751 |
| Minimum | 20150917 |
|---|---|
| Maximum | 20200420 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 20150917 |
|---|---|
| 5-th percentile | 20151009 |
| Q1 | 20170760 |
| median | 20180964 |
| Q3 | 20190803 |
| 95-th percentile | 20191676 |
| Maximum | 20200420 |
| Range | 49503 |
| Interquartile range (IQR) | 20043.25 |
Descriptive statistics
| Standard deviation | 14813.173 |
|---|---|
| Coefficient of variation (CV) | 0.00073409763 |
| Kurtosis | -0.73856238 |
| Mean | 20178751 |
| Median Absolute Deviation (MAD) | 9933.5 |
| Skewness | -0.62175492 |
| Sum | 8.0715005 × 108 |
| Variance | 2.1943011 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=37)
| Value | Count | Frequency (%) |
| 20190412 | 2 | 2.0% |
| 20171030 | 2 | 2.0% |
| 20170607 | 2 | 2.0% |
| 20190807 | 1 | 1.0% |
| 20190503 | 1 | 1.0% |
| 20180614 | 1 | 1.0% |
| 20200407 | 1 | 1.0% |
| 20200420 | 1 | 1.0% |
| 20171115 | 1 | 1.0% |
| 20190812 | 1 | 1.0% |
| Other values (27) | 27 | |
| (Missing) | 60 |
| Value | Count | Frequency (%) |
| 20150917 | 1 | |
| 20150925 | 1 | |
| 20151013 | 1 | |
| 20151028 | 1 | |
| 20151029 | 1 | |
| 20160220 | 1 | |
| 20160415 | 1 | |
| 20170215 | 1 | |
| 20170607 | 2 | |
| 20170811 | 1 |
| Value | Count | Frequency (%) |
| 20200420 | 1 | |
| 20200407 | 1 | |
| 20191216 | 1 | |
| 20191202 | 1 | |
| 20191031 | 1 | |
| 20190920 | 1 | |
| 20190905 | 1 | |
| 20190819 | 1 | |
| 20190812 | 1 | |
| 20190807 | 1 |
NALTREXONE_LST
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 40 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 60 |
| Missing (%) | 60.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20183202 |
| Minimum | 20151110 |
|---|---|
| Maximum | 20200427 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 20151110 |
|---|---|
| 5-th percentile | 20159665 |
| Q1 | 20171207 |
| median | 20190425 |
| Q3 | 20190946 |
| 95-th percentile | 20200408 |
| Maximum | 20200427 |
| Range | 49317 |
| Interquartile range (IQR) | 19738.5 |
Descriptive statistics
| Standard deviation | 13852.153 |
|---|---|
| Coefficient of variation (CV) | 0.00068632089 |
| Kurtosis | -0.1448259 |
| Mean | 20183202 |
| Median Absolute Deviation (MAD) | 9417 |
| Skewness | -0.90932666 |
| Sum | 8.0732807 × 108 |
| Variance | 1.9188214 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=40)
| Value | Count | Frequency (%) |
| 20190613 | 1 | 1.0% |
| 20180710 | 1 | 1.0% |
| 20200407 | 1 | 1.0% |
| 20200420 | 1 | 1.0% |
| 20171208 | 1 | 1.0% |
| 20200312 | 1 | 1.0% |
| 20190812 | 1 | 1.0% |
| 20190807 | 1 | 1.0% |
| 20191031 | 1 | 1.0% |
| 20171204 | 1 | 1.0% |
| Other values (30) | 30 | |
| (Missing) | 60 |
| Value | Count | Frequency (%) |
| 20151110 | 1 | |
| 20151119 | 1 | |
| 20160115 | 1 | |
| 20160211 | 1 | |
| 20160415 | 1 | |
| 20160824 | 1 | |
| 20170308 | 1 | |
| 20170614 | 1 | |
| 20171030 | 1 | |
| 20171204 | 1 |
| Value | Count | Frequency (%) |
| 20200427 | 1 | |
| 20200420 | 1 | |
| 20200407 | 1 | |
| 20200318 | 1 | |
| 20200312 | 1 | |
| 20191216 | 1 | |
| 20191202 | 1 | |
| 20191120 | 1 | |
| 20191031 | 1 | |
| 20191001 | 1 |
NALTREXONE_VALUE
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 9 |
|---|---|
| Distinct (%) | 22.5% |
| Missing | 60 |
| Missing (%) | 60.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.79 |
| Minimum | 12.5 |
|---|---|
| Maximum | 50 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 12.5 |
|---|---|
| 5-th percentile | 12.5 |
| Q1 | 12.5 |
| median | 50 |
| Q3 | 50 |
| 95-th percentile | 50 |
| Maximum | 50 |
| Range | 37.5 |
| Interquartile range (IQR) | 37.5 |
Descriptive statistics
| Standard deviation | 17.172993 |
|---|---|
| Coefficient of variation (CV) | 0.47982657 |
| Kurtosis | -1.6664605 |
| Mean | 35.79 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.53731937 |
| Sum | 1431.6 |
| Variance | 294.91169 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 50.0 | 21 | 21.0% |
| 12.5 | 12 | 12.0% |
| 42.5 | 1 | 1.0% |
| 45.6 | 1 | 1.0% |
| 20.7 | 1 | 1.0% |
| 33.9 | 1 | 1.0% |
| 16.4 | 1 | 1.0% |
| 37.5 | 1 | 1.0% |
| 35.0 | 1 | 1.0% |
| (Missing) | 60 |
| Value | Count | Frequency (%) |
| 12.5 | 12 | |
| 16.4 | 1 | 1.0% |
| 20.7 | 1 | 1.0% |
| 33.9 | 1 | 1.0% |
| 35.0 | 1 | 1.0% |
| 37.5 | 1 | 1.0% |
| 42.5 | 1 | 1.0% |
| 45.6 | 1 | 1.0% |
| 50.0 | 21 |
| Value | Count | Frequency (%) |
| 50.0 | 21 | |
| 45.6 | 1 | 1.0% |
| 42.5 | 1 | 1.0% |
| 37.5 | 1 | 1.0% |
| 35.0 | 1 | 1.0% |
| 33.9 | 1 | 1.0% |
| 20.7 | 1 | 1.0% |
| 16.4 | 1 | 1.0% |
| 12.5 | 12 |
LORAZEPAM_SCT
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 21 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 79 |
| Missing (%) | 79.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20175801 |
| Minimum | 20160211 |
|---|---|
| Maximum | 20200410 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 20160211 |
|---|---|
| 5-th percentile | 20160325 |
| Q1 | 20170211 |
| median | 20170711 |
| Q3 | 20181228 |
| 95-th percentile | 20200216 |
| Maximum | 20200410 |
| Range | 40199 |
| Interquartile range (IQR) | 11017 |
Descriptive statistics
| Standard deviation | 12556.088 |
|---|---|
| Coefficient of variation (CV) | 0.00062233407 |
| Kurtosis | -0.49469921 |
| Mean | 20175801 |
| Median Absolute Deviation (MAD) | 9807 |
| Skewness | 0.68429575 |
| Sum | 4.2369181 × 108 |
| Variance | 1.5765535 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 20170526 | 1 | 1.0% |
| 20181228 | 1 | 1.0% |
| 20191103 | 1 | 1.0% |
| 20170216 | 1 | 1.0% |
| 20170211 | 1 | 1.0% |
| 20190919 | 1 | 1.0% |
| 20200216 | 1 | 1.0% |
| 20170711 | 1 | 1.0% |
| 20180608 | 1 | 1.0% |
| 20160211 | 1 | 1.0% |
| Other values (11) | 11 | 11.0% |
| (Missing) | 79 |
| Value | Count | Frequency (%) |
| 20160211 | 1 | |
| 20160325 | 1 | |
| 20160522 | 1 | |
| 20160904 | 1 | |
| 20170204 | 1 | |
| 20170211 | 1 | |
| 20170216 | 1 | |
| 20170419 | 1 | |
| 20170526 | 1 | |
| 20170705 | 1 |
| Value | Count | Frequency (%) |
| 20200410 | 1 | |
| 20200216 | 1 | |
| 20191103 | 1 | |
| 20190919 | 1 | |
| 20190814 | 1 | |
| 20181228 | 1 | |
| 20180608 | 1 | |
| 20180127 | 1 | |
| 20170723 | 1 | |
| 20170712 | 1 |
LORAZEPAM_LCT
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 21 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 79 |
| Missing (%) | 79.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20178663 |
| Minimum | 20160325 |
|---|---|
| Maximum | 20200410 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 20160325 |
|---|---|
| 5-th percentile | 20160522 |
| Q1 | 20170419 |
| median | 20180213 |
| Q3 | 20190602 |
| 95-th percentile | 20200216 |
| Maximum | 20200410 |
| Range | 40085 |
| Interquartile range (IQR) | 20183 |
Descriptive statistics
| Standard deviation | 12153.152 |
|---|---|
| Coefficient of variation (CV) | 0.00060227735 |
| Kurtosis | -0.7688987 |
| Mean | 20178663 |
| Median Absolute Deviation (MAD) | 9997 |
| Skewness | 0.19073939 |
| Sum | 4.2375193 × 108 |
| Variance | 1.476991 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 20170526 | 1 | 1.0% |
| 20181228 | 1 | 1.0% |
| 20191103 | 1 | 1.0% |
| 20170216 | 1 | 1.0% |
| 20180803 | 1 | 1.0% |
| 20190919 | 1 | 1.0% |
| 20200216 | 1 | 1.0% |
| 20190602 | 1 | 1.0% |
| 20180608 | 1 | 1.0% |
| 20160529 | 1 | 1.0% |
| Other values (11) | 11 | 11.0% |
| (Missing) | 79 |
| Value | Count | Frequency (%) |
| 20160325 | 1 | |
| 20160522 | 1 | |
| 20160529 | 1 | |
| 20170204 | 1 | |
| 20170216 | 1 | |
| 20170419 | 1 | |
| 20170526 | 1 | |
| 20170705 | 1 | |
| 20170723 | 1 | |
| 20180127 | 1 |
| Value | Count | Frequency (%) |
| 20200410 | 1 | |
| 20200216 | 1 | |
| 20191103 | 1 | |
| 20190919 | 1 | |
| 20190814 | 1 | |
| 20190602 | 1 | |
| 20181228 | 1 | |
| 20180803 | 1 | |
| 20180714 | 1 | |
| 20180608 | 1 |
LORAZEPAM_VALUE
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 10 |
|---|---|
| Distinct (%) | 47.6% |
| Missing | 79 |
| Missing (%) | 79.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1666667 |
| Minimum | 0.9 |
|---|---|
| Maximum | 8.9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 0.9 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2.4 |
| 95-th percentile | 4 |
| Maximum | 8.9 |
| Range | 8 |
| Interquartile range (IQR) | 1.4 |
Descriptive statistics
| Standard deviation | 1.7720986 |
|---|---|
| Coefficient of variation (CV) | 0.81789165 |
| Kurtosis | 10.765946 |
| Mean | 2.1666667 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.9743745 |
| Sum | 45.5 |
| Variance | 3.1403333 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 1.0 | 7 | 7.0% |
| 2.0 | 4 | 4.0% |
| 3.0 | 3 | 3.0% |
| 1.8 | 1 | 1.0% |
| 8.9 | 1 | 1.0% |
| 2.1 | 1 | 1.0% |
| 2.4 | 1 | 1.0% |
| 4.0 | 1 | 1.0% |
| 1.4 | 1 | 1.0% |
| 0.9 | 1 | 1.0% |
| (Missing) | 79 |
| Value | Count | Frequency (%) |
| 0.9 | 1 | 1.0% |
| 1.0 | 7 | |
| 1.4 | 1 | 1.0% |
| 1.8 | 1 | 1.0% |
| 2.0 | 4 | |
| 2.1 | 1 | 1.0% |
| 2.4 | 1 | 1.0% |
| 3.0 | 3 | |
| 4.0 | 1 | 1.0% |
| 8.9 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 8.9 | 1 | 1.0% |
| 4.0 | 1 | 1.0% |
| 3.0 | 3 | |
| 2.4 | 1 | 1.0% |
| 2.1 | 1 | 1.0% |
| 2.0 | 4 | |
| 1.8 | 1 | 1.0% |
| 1.4 | 1 | 1.0% |
| 1.0 | 7 | |
| 0.9 | 1 | 1.0% |
| _ID | RID | ACAMPROSTATE_SCT | ACAMPROSTATE_LST | ACAMPROSTATE_VALUE | NALTREXONE_SCT | NALTREXONE_LST | NALTREXONE_VALUE | LORAZEPAM_SCT | LORAZEPAM_LCT | LORAZEPAM_VALUE | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| _ID | 1.000 | 1.000 | 0.342 | 0.307 | 0.359 | 0.393 | 0.000 | 0.307 | 0.000 | 0.000 | 0.000 |
| RID | 1.000 | 1.000 | 0.342 | 0.307 | 0.359 | 0.393 | 0.000 | 0.307 | 0.000 | 0.000 | 0.000 |
| ACAMPROSTATE_SCT | 0.342 | 0.342 | 1.000 | 0.939 | 0.283 | 0.968 | 0.883 | 0.461 | 0.906 | 0.784 | 0.830 |
| ACAMPROSTATE_LST | 0.307 | 0.307 | 0.939 | 1.000 | 0.163 | 0.864 | 0.951 | 0.493 | 0.677 | 0.650 | 0.000 |
| ACAMPROSTATE_VALUE | 0.359 | 0.359 | 0.283 | 0.163 | 1.000 | 0.279 | 0.455 | 0.624 | 0.577 | 0.339 | 0.000 |
| NALTREXONE_SCT | 0.393 | 0.393 | 0.968 | 0.864 | 0.279 | 1.000 | 0.812 | 0.000 | 1.000 | 0.771 | 0.647 |
| NALTREXONE_LST | 0.000 | 0.000 | 0.883 | 0.951 | 0.455 | 0.812 | 1.000 | 0.068 | 0.598 | 0.913 | 0.568 |
| NALTREXONE_VALUE | 0.307 | 0.307 | 0.461 | 0.493 | 0.624 | 0.000 | 0.068 | 1.000 | 1.000 | 0.416 | 0.000 |
| LORAZEPAM_SCT | 0.000 | 0.000 | 0.906 | 0.677 | 0.577 | 1.000 | 0.598 | 1.000 | 1.000 | 0.961 | 0.474 |
| LORAZEPAM_LCT | 0.000 | 0.000 | 0.784 | 0.650 | 0.339 | 0.771 | 0.913 | 0.416 | 0.961 | 1.000 | 0.334 |
| LORAZEPAM_VALUE | 0.000 | 0.000 | 0.830 | 0.000 | 0.000 | 0.647 | 0.568 | 0.000 | 0.474 | 0.334 | 1.000 |
| _ID | RID | ACAMPROSTATE_SCT | ACAMPROSTATE_LST | ACAMPROSTATE_VALUE | NALTREXONE_SCT | NALTREXONE_LST | NALTREXONE_VALUE | LORAZEPAM_SCT | LORAZEPAM_LCT | LORAZEPAM_VALUE | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| _ID | 1.000 | 1.000 | 0.041 | -0.006 | 0.042 | -0.148 | -0.067 | -0.085 | 0.126 | 0.266 | 0.048 |
| RID | 1.000 | 1.000 | 0.041 | -0.006 | 0.042 | -0.148 | -0.067 | -0.085 | 0.126 | 0.266 | 0.048 |
| ACAMPROSTATE_SCT | 0.041 | 0.041 | 1.000 | 0.860 | 0.108 | 0.968 | 0.888 | -0.291 | 0.896 | 0.738 | 0.299 |
| ACAMPROSTATE_LST | -0.006 | -0.006 | 0.860 | 1.000 | 0.135 | 0.881 | 0.963 | -0.403 | 0.770 | 0.739 | 0.330 |
| ACAMPROSTATE_VALUE | 0.042 | 0.042 | 0.108 | 0.135 | 1.000 | -0.009 | 0.052 | 0.267 | 0.298 | 0.026 | -0.036 |
| NALTREXONE_SCT | -0.148 | -0.148 | 0.968 | 0.881 | -0.009 | 1.000 | 0.866 | -0.307 | 0.771 | 0.543 | 0.759 |
| NALTREXONE_LST | -0.067 | -0.067 | 0.888 | 0.963 | 0.052 | 0.866 | 1.000 | -0.345 | 0.829 | 0.486 | 0.577 |
| NALTREXONE_VALUE | -0.085 | -0.085 | -0.291 | -0.403 | 0.267 | -0.307 | -0.345 | 1.000 | -0.169 | -0.507 | 0.144 |
| LORAZEPAM_SCT | 0.126 | 0.126 | 0.896 | 0.770 | 0.298 | 0.771 | 0.829 | -0.169 | 1.000 | 0.847 | 0.160 |
| LORAZEPAM_LCT | 0.266 | 0.266 | 0.738 | 0.739 | 0.026 | 0.543 | 0.486 | -0.507 | 0.847 | 1.000 | 0.274 |
| LORAZEPAM_VALUE | 0.048 | 0.048 | 0.299 | 0.330 | -0.036 | 0.759 | 0.577 | 0.144 | 0.160 | 0.274 | 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.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| _ID | RID | ACAMPROSTATE_SCT | ACAMPROSTATE_LST | ACAMPROSTATE_VALUE | NALTREXONE_SCT | NALTREXONE_LST | NALTREXONE_VALUE | LORAZEPAM_SCT | LORAZEPAM_LCT | LORAZEPAM_VALUE | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 1 | 20190424 | 20200403 | 1332.0 | 20190622 | 20190719 | 12.5 | 20190814 | 20190814 | 2.0 |
| 1 | 2 | 2 | 20150909 | 20200417 | 11988.0 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 2 | 3 | 3 | 20190910 | 20191120 | 4405.8 | 20190819 | 20191120 | 12.5 | <NA> | <NA> | <NA> |
| 3 | 4 | 4 | 20170215 | 20170308 | 10489.5 | 20170215 | 20170308 | 50.0 | <NA> | <NA> | <NA> |
| 4 | 5 | 5 | 20200402 | 20200402 | 5328.0 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 5 | 6 | 6 | 20151026 | 20151026 | 1332.0 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 6 | 7 | 7 | 20190927 | 20191108 | 333.0 | 20190905 | 20190927 | 12.5 | <NA> | <NA> | <NA> |
| 7 | 8 | 8 | 20161018 | 20161129 | 2456.4 | <NA> | <NA> | <NA> | 20170526 | 20170526 | 1.0 |
| 8 | 9 | 9 | 20200103 | 20200103 | 2997.0 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 9 | 10 | 10 | 20191105 | 20191125 | 2997.0 | 20191216 | 20191216 | 12.5 | <NA> | <NA> | <NA> |
| _ID | RID | ACAMPROSTATE_SCT | ACAMPROSTATE_LST | ACAMPROSTATE_VALUE | NALTREXONE_SCT | NALTREXONE_LST | NALTREXONE_VALUE | LORAZEPAM_SCT | LORAZEPAM_LCT | LORAZEPAM_VALUE | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 90 | 91 | 91 | 20150925 | 20160115 | 11988.0 | 20150925 | 20160115 | 12.5 | <NA> | <NA> | <NA> |
| 91 | 92 | 92 | 20190517 | 20200318 | 1332.0 | 20190412 | 20200318 | 12.5 | <NA> | <NA> | <NA> |
| 92 | 93 | 93 | 20181228 | 20181228 | 6406.3 | <NA> | <NA> | <NA> | 20181228 | 20181228 | 0.9 |
| 93 | 94 | 94 | 20200219 | 20200427 | 6290.4 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 94 | 95 | 95 | 20170801 | 20170801 | 2997.0 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 95 | 96 | 96 | 20171010 | 20190228 | 6738.2 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 96 | 97 | 97 | 20190821 | 20190821 | 11988.0 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 97 | 98 | 98 | 20190924 | 20200310 | 5328.0 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 98 | 99 | 99 | 20150917 | 20161005 | 586.6 | 20150917 | 20151119 | 12.5 | <NA> | <NA> | <NA> |
| 99 | 100 | 100 | 20200210 | 20200224 | 1332.0 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |