Creating a table from outputs

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.

回答(1 个)

Ganesh Regoti
Ganesh Regoti 2020-1-17
编辑:Ganesh Regoti 2020-1-17

0 个投票

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!

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

产品

版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by