I have a longitudinal data table in SQL that consists of 100 individuals’ 6 medical test records taken at 3 different time points. The dataset is 3 dimensional and I want to import it as a NumPy array with ndim=3 and shape of (100, 3, 6) in Python.
Here is a sample of the data elements of the first two cases (ID 001 and ID 002):
How could I do that?
Thank you in advance!