I have a dataset where for the same patient and time we have extracted different samples from different locations.
What would be the best way to encode this in MAE?
|Patient||Time||Region||State of the region|
The sampleMap is provides "many-to-one" mapping, but when those phenotypes are from each sample how should I store it? I have several variables related to the patient (sex, age of diagnosis, disease, C-reactive protein, treatment followed, antibiotics, ...) and some related to the sample mainly (date of extraction, region extracted, state of that region, Endoscopic Score of the region, type of sample, ...)
The only way I thought is using as ID a combination of Patient, Time and Location, something like
paste(Patient, Time, Location, collapse = "_") of the samples but it would duplicate information about the patient in order to store correctly the information about the sample.
Is there any better solution?