Comparing rows of a table

Question

BN 2020-4-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/517006-comparing-rows-of-a-table

评论： Tommy 2020-4-11

test.mat

Hey all,

I have a table, this table represents the value of creation coefficient (CC) and RMSE for 3 of my models. Now in each row, I want to compare CC and RMSE rows by rows. I would like to print the name of each model that has the nearest value to one (in comparison with each model) for CC after existing rows, and similarly, type then name of that model which has a lower value of RMSE.

So the output is a table just like that I attached but with 2 extra columns after existing columns now, one for CC and one for RMSE.

Here is a simple example:

Before:

After:

Please tell me how I can do this,

Thank you so much

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Tommy 2020-4-10

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/517006-comparing-rows-of-a-table#answer_425287

在 MATLAB Online 中打开

Let me know if this works:

[~,i] = min(1-[TEST.model1_CC, TEST.model2_CC, TEST.model3_CC],[],2);
[~,i2] = min([TEST.model1_RMSE, TEST.model2_RMSE, TEST.model3_RMSE],[],2);
names = TEST{1,{'model1','model2','model3'}}';
TEST.CC_CHECK = names(i);
TEST.RMSE_CHECK = names(i2);

3 个评论
显示 1更早的评论隐藏 1更早的评论

BN 2020-4-11

编辑：BN 2020-4-11

An Error Occurred when I clicked on Accept answer, I saw this problem earlier a few times, It will be fixed in a few hours, automatically. I click on accept answer a few hours later again.

Tommy 2020-4-11