EHDEN / ETL-UK-Biobank

ETL UK-Biobank
https://ehden.github.io/ETL-UK-Biobank/
12 stars 4 forks source link

gp_clinical one-to-many mapping #350

Closed MaximMoinat closed 2 years ago

MaximMoinat commented 2 years ago

In the GP Clinical mappings (general, emis, tpp) we do not allow one-to-many mappings. i.e. the first_only argument of the lookup is always set to True.

However, there are some cases where we want a one-to-many mapping, e.g. READ:65KZ.00 DT (double) + polio vacc. NOS maps to two drugs (diphtheria vaccin, tetanus vaccin) and a procedure (Administration of ... vaccin). By taking the first only we are arbitrarily selecting one which leads to a misrepresenting of the data.