Comparing rows of a table
조회 수: 15 (최근 30일)
이전 댓글 표시
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
채택된 답변
Tommy
2020년 4월 10일
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
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Time Series Objects에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!