- Convert the spread sheet data into table format.
Creating a table from outputs
3 views (last 30 days)
Show older comments
I've been trying to create a table to display results neatly. The purpose of the code is to match patient between two spreadsheets based on Age & BMI. Then to take those matches and display them in a table.
Match=zeros(46,10);
Found=zeros(50);
for y=1:length(En.SubNumE)
if ismember(Pen.AgeP(Target),En.AgeE(y)+(-2:2)) && ismember(Pen.BMIP(Target),En.BMIE(y)+(-2:0.1:2))
Match(y) = 1;
Found(j) = En.SubNumE(y);
j=j+1;
end
end
I'm not sure how to proceed. I successfully had a table when the data set was much smaller (10 vs 50). I want to display the Subject Number, Last Name, Age, and BMI for the matched people.
0 Comments
Answers (1)
Ganesh Regoti
on 17 Jan 2020
Edited: Ganesh Regoti
on 17 Jan 2020
Hi,
I understand that you want to compare data from spreadsheets with small tolerance and display the output as tables.
Steps:
Hope this helps!
0 Comments
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!