Creating a table from outputs

6 次查看（过去 30 天）
Katherine Medina
Katherine Medina 2020-1-8
编辑： Ganesh Regoti 2020-1-17
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
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!

类别

在 Help Center 和 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