Table 1 An example of raw data
From: An automated data cleaning method for Electronic Health Records by incorporating clinical knowledge
Patient ID | GP ID | Birth year | Sex | Test code | Date | Year | Test name | Num1 | Num2 | Unit |
|---|---|---|---|---|---|---|---|---|---|---|
27898 | GP_9811 | 1957 | F | S00000057 | 09/08/2014 | 2014 | 165 | 0 | cm | |
27898 | GP_9811 | 1957 | F | S00000058 | 09/08/2014 | 2014 | 56.5 | 0 | kg | |
27898 | GP_9811 | 1957 | F | S00000057 | 29/09/1995 | 1995 | Height | 163 | 0 | S002 |
27898 | GP_9811 | 1957 | F | S00000058 | 29/09/1995 | 1995 | Weight | 61 | 0 | S006 |
42716 | GP_9812 | 1963 | M | S00000069 | 18/11/2013 | 2013 | 1 | 130 | 88 | mmHg |
61905 | GP_9845 | 1964 | F | S00000069 | 16/08/1993 | 1993 | Blood pressure | 90 | 50 | mmHg |