Creating a table from outputs

3 views (last 30 days)
Katherine Medina
Katherine Medina on 8 Jan 2020
Edited: Ganesh Regoti on 17 Jan 2020
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.

Answers (1)

Ganesh Regoti
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:
  1. Convert the spread sheet data into table format.
2. You can use ismembertol function to check the data between two tables.
Hope this helps!

Categories

Find more on Tables in Help Center and File Exchange

Products


Release

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!