comparing matices that contain numbers and NaNs

Question

antonet 2012-7-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42758-comparing-matices-that-contain-numbers-and-nans

 I have 2 cell matrices R and W and I want to check  if they contain the same elements. Specifically, I want to compare R which is obtained from

[N,T,R] = xlsread( filename); %

 with another matrix W.Both matrices are cell matrices and can also contain NaN entries.

My goal: If my calculations are correct then

kk=W(7 ,3:end); should contain the same elements with

zz1=R(7,3:end);

or zz2=R(8,3:end);

So to test this I do something like

if zz==xx1 | zz== xx2

'OK' else 'Not OK' EndThe problem is that

zz==xx1

??? Undefined function or method 'eq' for input arguments of type 'cell'.

So I use cell2mat(zz)==cell2mat(xx1) and it works.

But if zz and xx1 contain NaN then for some reason I cannot use the cell2mat() approach

I am looking for a general approach that will enable me to do that comparison whether I have NaN and numbers or only numbers’

thanks

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

Jan 2012-7-5

@Readers: It seems like anonet wants to compare cells, which contain numerical and string values.

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2012-7-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42758-comparing-matices-that-contain-numbers-and-nans#answer_52618

编辑：Andrei Bobrov 2012-7-5

在 MATLAB Online 中打开

variant of comparison cell arrays (edit)

A = {...
[84]    [ 93]    [   109]
[99]    [NaN]    [    62]
[29]    [123]    'dgdgdg'};
B = {...
[84]    [ 93]    [   109]
[99]    [NaN]    [    62]
[29]    [123]    'dgdgdg'};
A1=A;
B1=B;
A1(cellfun(@(x)all(isnan(x)),A)) = {0};
B1(cellfun(@(x)all(isnan(x)),B)) = {0};
out = isequal(A1,B1);

4 个评论
显示 2更早的评论隐藏 2更早的评论

antonet 2012-7-5

编辑：antonet 2012-7-5

在 MATLAB Online 中打开

can i omit

A1=A;

B1=B;

so as to simlpy have

 A = {...
[84]    [ 93]    [   109]
[99]    [NaN]    [    62]
[29]    [123]    'dgdgdg'};
B = {...
[84]    [ 93]    [   109]
[99]    [NaN]    [    62]
[29]    [123]    'dgdgdg'};

A(cellfun(@(x)all(isnan(x)),A)) = {0};

B(cellfun(@(x)all(isnan(x)),B)) = {0};

out = isequal(A,B)

thanks

Andrei Bobrov 2012-7-5

Hi Antonet! Thank you for "Accepted answer", but I mean that Jan's answer better.

请先登录，再进行评论。

Answer 2

Jan 2012-7-5

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42758-comparing-matices-that-contain-numbers-and-nans#answer_52617

在 MATLAB Online 中打开

C1 = {'String1', 23, -17, NaN,  1:29);
C2 = {'String2', 24, -17.3, 21, 1:30);
C3 = {'String1', 23, -17, NaN,  1:29);
% |C1==C2| fails!
isequalwithequalnans(C1, C2)
isequalwithequalnans(C1, C3)

I cannot test this currently. When NaNs should be assumed to be different, isequal would do it.

4 个评论
显示 2更早的评论隐藏 2更早的评论

Teja Muppirala 2012-7-5

On more recent releases, there is the ISEQUALN function so you don't have to write out ISEQUALWITHEQUALNANS

antonet 2012-7-5

what is +1 means?

请先登录，再进行评论。

Answer 3

Kevin Claytor 2012-7-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42758-comparing-matices-that-contain-numbers-and-nans#answer_52586

My guess from searching the help docs for 'cell' gives;

m = cell2mat(c) converts a multidimensional cell array c with contents of the same data type into a single matrix, m.

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

Walter Roberson 2012-7-5

What do you want to have happen in the locations that contain strings? It is not possible for a numeric array to contain strings.

Jan 2012-7-5

@antonet: Please provide the necessary information in the original question, because readers in this forum will read it at first. Therefore you can edit the question.

The code you have posted is hard to read. Please read the instructions about code formatting again.

请先登录，再进行评论。