comparing matices that contain numbers and NaNs

4 visualizzazioni (ultimi 30 giorni)
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 Commento
Jan
Jan il 5 Lug 2012
@Readers: It seems like anonet wants to compare cells, which contain numerical and string values.

Accedi per commentare.

Risposta accettata

Andrei Bobrov
Andrei Bobrov il 5 Lug 2012
Modificato: Andrei Bobrov il 5 Lug 2012
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 Commenti
antonet
antonet il 5 Lug 2012
Modificato: antonet il 5 Lug 2012
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
Andrei Bobrov il 5 Lug 2012
Hi Antonet! Thank you for "Accepted answer", but I mean that Jan's answer better.

Accedi per commentare.

Più risposte (2)

Jan
Jan il 5 Lug 2012
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 Commenti
Teja Muppirala
Teja Muppirala il 5 Lug 2012
On more recent releases, there is the ISEQUALN function so you don't have to write out ISEQUALWITHEQUALNANS

Accedi per commentare.


Kevin Claytor
Kevin Claytor il 4 Lug 2012
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 Commenti
Walter Roberson
Walter Roberson il 5 Lug 2012
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
Jan il 5 Lug 2012
@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.

Accedi per commentare.

Categorie

Scopri di più su Cell Arrays in Help Center e File Exchange

Tag

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by