I need to compare elements that come from different tables

Question

Ivan 2024-8-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2148216-i-need-to-compare-elements-that-come-from-different-tables

评论： Voss 2024-8-28

I am developing a code and have used the 'fitlme' tool to perform a mixed-effects regression. Once the regression is done, a table named 'Bnames_inter' is generated, which has a column named 'Level' where numbers are stored that I later need to compare with the numbers from another table. I believe my problem lies in the nature of the variables I want to compare, and that's why I am asking for help.

Here are the lines of code I am working on.

Nature of Bnames_inter.Level(1)

ans =

1×1 cell array

{'6000038'}

Nature of EQID_inter(1)

ans =

6000152

delta_inter = [];

for i = 1:length(eta_inter)

if EQID_inter(i) == Bnames_inter.Level(i)

delta_inter = [delta_inter, res_inter_3(i) - eta_inter(i) - c0_inter];

end

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

请先登录，再进行评论。

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

Answer 1

Voss 2024-8-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2148216-i-need-to-compare-elements-that-come-from-different-tables#answer_1505929

在 MATLAB Online 中打开

EQID_inter is a numeric array.

Bnames_inter.Level is a cell array (whose first element contains the character vector '6000038').

You cannot compare a numeric array to a cell array.

Example:

% variables like yours, as far as I can tell:
Bnames_inter = table({'6000038';'6000039';'6000040'},'VariableNames',{'Level'});
EQID_inter = [6000152; 6000153; 6000154];
% confirming that these are the same as you show in the question:
Bnames_inter.Level(1)
ans = 1x1 cell array
    {'6000038'}
EQID_inter(1)
ans = 6000152
try % try to compare a numeric array to a cell array
    i = 1;
    EQID_inter(i) == Bnames_inter.Level(i)
catch err % can't do it, show the error message (see below)
    disp(err.message)
end
Undefined function 'eq' for input arguments of type 'cell'.

If you make Bnames_inter.Level a numeric array, then the comparison will work. To do that, make appropriate modifications to the code that creates Bnames_inter, or leave that code alone and convert Bnames_inter.Level after the fact.

The following conversion may or may not work (I don't know because I don't have your actual variables):

format long g % format for display purposes only
% convert Bnames_inter.Level from cell array of character 
% vectors (presumed) to numeric array using str2double:
Bnames_inter.Level = str2double(Bnames_inter.Level)
Bnames_inter = 3x1 table
     Level 
    _______

    6000038
    6000039
    6000040
% now Bnames_inter.Level is numeric, and the comparison works:
i = 1;
EQID_inter(i) == Bnames_inter.Level(i)
ans = logical
   0