Table 1 Summary of laboratory variables with missingness <75% before the event from two EHR datasets.
From: Imputation of missing values for electronic health record laboratory data
LONIC ID | Component | Ischemic stroke (Geisinger, n = 9037) | Heart Failure (Sutter Health, n = 5192) | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Missing% before eventa | Missing% after event | Mean (SD) before event | Mean (SD) after event | Corr | Missing% before event | Missing% after event | Mean (SD) before event | Mean (SD) after event | Corr | ||
1742-6 | Alanine aminotransferase | 63.77 | 67.69 | 32.903 (13.526) | 30.757 (13.142) | 0.412 | |||||
1743-4 | Alanine aminotransferase | 46.52 | 25.10 | 21.683 (10.840) | 22.661 (12.121) | 0.453 | |||||
1751-7 | Albumin | 63.46 | 66.76 | 3.603 (0.435) | 3.611 (0.387) | 0.495 | |||||
61151-7 | Albumin | 46.80 | 20.49 | 3.941 (0.501) | 3.750 (0.517) | 0.535 | |||||
6768-6 | Alkaline phosphatase | 48.71 | 24.42 | 81.756 (27.609) | 78.844 (27.251) | 0.672 | 65.21 | 68.47 | 90.617 (29.471) | 91.361 (32.130) | 0.631 |
10466-1 | Anion gap 3 | 40.66 | 4.26 | 10.515 (3.218) | 10.17 (3.170) | 0.443 | |||||
1920-8 | Aspartate aminotransferase | 64.87 | 68.22 | 23.651 (9.351) | 23.399 (8.971) | 0.430 | |||||
30239-8 | Aspartate aminotransferase | 48.28 | 26.20 | 24.519 (8.921) | 25.530 (9.762) | 0.385 | |||||
704-7b | Basophils | 53.09 | 16.73 | −1.452 (0.296) | −1.497 (0.292) | 0.517 | |||||
706-2b | Basophils/100 leukocytes | 48.48 | 9.90 | −7.679 (10.008) | −8.652 (10.205) | 0.402 | 65.71 | 68.71 | 0.486 (0.553) | 0.492 (0.556) | 0.398 |
1975-2 | Bilirubin | 48.94 | 25.06 | 0.531 (0.291) | 0.577 (0.314) | 0.550 | 65.22 | 68.89 | 0.554 (0.261) | 0.571 (0.259) | 0.566 |
17861-6 | Calcium | 36.08 | 2.26 | 9.272 (0.55) | 8.924 (0.522) | 0.416 | 58.46 | 60.52 | 9.004 (0.481) | 9.031 (0.466) | 0.448 |
2028-9 | Carbon dioxide | 36.10 | 2.14 | 26.834 (3.035) | 25.446 (3.121) | 0.467 | 58.51 | 60.49 | 27.806 (3.038) | 28.081 (3.177) | 0.494 |
2075-0 | Chloride | 36.18 | 2.25 | 101.975 (3.925) | 103.781 (4.128) | 0.507 | 58.49 | 60.49 | 103.437 (3.727) | 103.003 (3.982) | 0.514 |
2093-3 | Cholesterol | 53.62 | 16.60 | 178.579 (46.356) | 166.091 (45.681) | 0.597 | 66.88 | 72.73 | 164.172 (42.202) | 159.966 (42.207) | 0.590 |
2085-9 | Cholesterol in HDL | 54.00 | 16.76 | 48.050 (14.786) | 44.925 (14.348) | 0.720 | 67.00 | 72.72 | 51.009 (16.625) | 50.845 (16.035) | 0.764 |
13457-7 | Cholesterol in LDL | 55.14 | 18.46 | 99.853 (38.611) | 92.945 (38.177) | 0.586 | 67.52 | 73.11 | 87.573 (34.429) | 83.182 (34.584) | 0.569 |
9830-1 | Cholesterol.total/Cholesterol.in HDL | 55.47 | 19.43 | 3.958 (1.393) | 3.948 (1.433) | 0.683 | 67.03 | 72.87 | 3.444 (1.173) | 3.342 (1.116) | 0.631 |
5902-2 | Coagulation tissue factor induced | 67.83 | 29.91 | 14.233 (1.839) | 14.379 (1.642) | 0.456 | |||||
6301-6 | Coagulation tissue factor induced.INR | 68.32 | 30.59 | 1.108 (0.173) | 1.124 (0.161) | 0.450 | |||||
2160-0 | Creatinine | 38.41 | 6.16 | 1.009 (0.325) | 0.954 (0.321) | 0.804 | 58.49 | 61.06 | 1.06 (0.369) | 1.147 (0.434) | 0.723 |
711-2b | Eosinophils | 51.30 | 15.77 | −0.828 (0.388) | −0.918 (0.426) | 0.381 | 66.76 | 68.98 | 0.209 (0.145) | 0.210 (0.149) | 0.506 |
713-8b | Eosinophils/100 leukocytes | 51.34 | 20.02 | 0.325 (0.347) | 0.254 (0.385) | 0.353 | 66.02 | 69.11 | 2.886 (1.927) | 2.947 (2.026) | 0.454 |
788-0 | Erythrocyte distribution width | 41.36 | 4.43 | 13.944 (1.307) | 13.837 (1.246) | 0.770 | 63.84 | 66.19 | 14.292 (1.332) | 14.526 (1.486) | 0.571 |
785-6 | Erythrocyte mean corpuscular hemoglobin | 40.17 | 3.18 | 30.294 (2.113) | 30.323 (2.084) | 0.876 | 63.57 | 65.95 | 29.946 (2.129) | 29.856 (2.323) | 0.778 |
786-4 | Erythrocyte mean corpuscular hemoglobin concentration | 39.95 | 2.80 | 33.425 (1.239) | 33.597 (1.190) | 0.699 | 63.23 | 65.78 | 32.648 (1.233) | 32.468 (1.258) | 0.610 |
787-2 | Erythrocyte mean corpuscular volume | 40.12 | 3.07 | 90.546 (5.439) | 90.162 (5.324) | 0.861 | 63.40 | 65.85 | 91.673 (5.859) | 91.888 (6.060) | 0.780 |
789-8 | Erythrocytes | 39.89 | 2.79 | 4.329 (0.637) | 4.289 (0.610) | 0.731 | 63.24 | 65.80 | 4.304 (0.587) | 4.24 (0.575) | 0.664 |
2345-7 | Glucose | 38.77 | 4.32 | 119.727 (38.239) | 120.475 (36.528) | 0.452 | 59.59 | 61.89 | 113.58 (33.589) | 113.365 (32.696) | 0.413 |
4544-3 | Hematocrit | 39.75 | 2.68 | 39.048 (5.377) | 38.556 (5.178) | 0.698 | 63.04 | 65.66 | 39.292 (5.078) | 38.786 (4.992) | 0.617 |
718-7 | Hemoglobin | 39.26 | 2.61 | 13.081 (1.943) | 12.965 (1.891) | 0.728 | 62.97 | 65.63 | 12.836 (1.821) | 12.614 (1.804) | 0.637 |
17856-6 | Hemoglobin A1c/Hemoglobin.total | 71.09 | 40.69 | 7.025 (1.633) | 6.489 (1.502) | 0.743 | |||||
6690-2 | Leukocytes | 40.28 | 4.11 | 8.079 (2.665) | 8.559 (2.939) | 0.460 | 63.57 | 66.10 | 7.475 (2.424) | 7.341 (2.306) | 0.518 |
731-0 | Lymphocytes | 48.11 | 9.25 | 1.726 (0.777) | 1.732 (0.778) | 0.628 | 66.76 | 68.88 | 1.698 (0.666) | 1.624 (0.670) | 0.633 |
736-9 | Lymphocytes/100 leukocytes | 47.53 | 8.75 | 22.22 (9.565) | 21.644 (10.113) | 0.503 | 65.75 | 68.71 | 23.995 (9.045) | 23.283 (9.288) | 0.518 |
742-7 | Monocytes | 48.00 | 9.45 | 0.681 (0.276) | 0.71 (0.289) | 0.451 | 66.71 | 68.88 | 0.672 (0.253) | 0.662 (0.245) | 0.513 |
5905-5 | Monocytes/100 leukocytes | 47.67 | 9.11 | 8.486 (2.844) | 8.43 (2.756) | 0.413 | 65.78 | 68.76 | 9.19 (2.693) | 9.249 (2.840) | 0.487 |
751-8 | Neutrophils | 56.27 | 38.43 | 5.451 (2.424) | 5.866 (2.736) | 0.372 | 66.90 | 69.08 | 4.783 (1.992) | 4.725 (1.897) | 0.401 |
770-8 | Neutrophils/100 leukocytes | 48.76 | 10.05 | 65.687 (11.447) | 66.926 (12.089) | 0.412 | 65.73 | 68.69 | 63.234 (10.551) | 63.738 (10.894) | 0.436 |
32623-1 | Platelet mean volume | 40.10 | 2.85 | 9.854 (1.397) | 9.746 (1.328) | 0.752 | |||||
777-3 | Platelets | 40.12 | 3.07 | 232.984 (75.418) | 216.817 (68.570) | 0.723 | 63.46 | 66.09 | 228.131 (70.929) | 226.625 (74.628) | 0.660 |
2823-3 | Potassium | 35.89 | 2.40 | 4.256 (0.481) | 4.008 (0.447) | 0.328 | 58.09 | 60.39 | 4.262 (0.463) | 4.281 (0.484) | 0.391 |
2885-2 | Protein | 47.63 | 22.66 | 6.874 (0.647) | 6.659 (0.673) | 0.448 | 64.70 | 68.15 | 7.153 (0.585) | 7.173 (0.584) | 0.525 |
2951-2 | Sodium | 36.51 | 2.37 | 139.234 (3.318) | 139.361 (3.181) | 0.461 | 58.44 | 60.42 | 139.45 (3.184) | 139.271 (3.384) | 0.473 |
3016-3 | Thyrotropin | 62.75 | 44.23 | 2.249 (1.485) | 2.311 (1.600) | 0.478 | |||||
2571-8 | Triglyceride | 55.28 | 17.90 | 142.896 (70.842) | 131.657 (67.640) | 0.603 | 67.35 | 73.22 | 120.268 (61.561) | 122.985 (64.578) | 0.581 |
3094-0 | Urea nitrogen | 37.16 | 4.02 | 19.239 (8.073) | 17.617 (7.760) | 0.622 | 59.02 | 61.13 | 21.187 (9.096) | 23.187 (10.671) | 0.599 |
50560-2 | Urine pH | 61.62 | 36.73 | 6.009 (0.790) | 6.034 (0.773) | 0.189 | |||||
13458-5 | Cholesterol in VLDL | 74.10 | 78.43 | 24.308 (12.754) | 25.067 (13.391) | 0.610 | |||||
