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.

Answer 1

[Ganesh Regoti]

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.

https://www.mathworks.com/matlabcentral/answers/386016-the-loop-for-comparing-two-excels-row-by-row

2. You can use ismembertol function to check the data between two tables.

https://www.mathworks.com/matlabcentral/answers/195256-is-there-a-way-to-use-setdiff-or-any-function-to-compare-two-data-sets-within-a-range-of-each-other

Hope this helps!