I have a large table that has several groups of similar variables. I'd like to create levels of variables so I can group and access them easily- perhaps I need a struct or perhaps I am being lazy.
T1 = table(LastName,Gender,Age,Height,Weight,Systolic,Diastolic);
head(T1,3)
ans =
LastName Gender Age Height Weight Systolic Diastolic
____________ __________ ___ ______ ______ ________ _________
{'Smith' } {'Male' } 38 71 176 124 93
{'Johnson' } {'Male' } 43 69 163 109 77
{'Williams'} {'Female'} 38 64 131 125 83
I can merge variables, but I seem to lose the nested variable names.
T2 = mergevars(T1,{'Systolic','Diastolic'},'NewVariableName','BloodPressure');
head(T2,3)
ans =
LastName Gender Age Height Weight BloodPressure
____________ __________ ___ ______ ______ _____________
{'Smith' } {'Male' } 38 71 176 124 93
{'Johnson' } {'Male' } 43 69 163 109 77
{'Williams'} {'Female'} 38 64 131 125 83
I'd like to be able to access the Systolic and Diastolic variable under BloodPressure like this:
T2.BloodPressure.Systolic
T2.BloodPressure(:,1)
It's a lot harder for me to keep track of the index, and I am hoping I would be able to use Tab Completion.
Also, in the event there is more than one 'Blood Pressure', say I have BloodPressure1 and BloodPressure2 both with sub variables Systolic and DIastolic, I'd like to be able to get all the Systolics at once- something like
Hope that explains what I'm after, and hoping there's a way to get there. Thanks.
