separate empty cells (NaN) from others
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Amr Hashem
am 25 Jul. 2015
Kommentiert: Amr Hashem
am 25 Jul. 2015
I have a table of cells ( ex: 100*75 cell)
and i want to focus on column 12 , if any cell in it is NaN (empty) , i want to separate its row from the table.
i use this code:
[ndata text alldata] = xlsread('mdr1.xls','sheet1');
[R1,C1]=size(alldata);
j=1;
K=1;
for i=1:size(alldata,1)
if isnan(alldata{i,12})
Ndate(j)=i;
j=j+1;
else
Ydate(K)=i;
K=K+1;
end
end
NAdate=alldata(Ndate,:);
DDate=alldata(Ydate,:);
xlswrite('separate.xls',DDate,1);
xlswrite('separate.xls',NADate,2);
it works...
but
I wonder if anyone has an idea to modify this code.
0 Kommentare
Akzeptierte Antwort
Azzi Abdelmalek
am 25 Jul. 2015
Bearbeitet: Azzi Abdelmalek
am 25 Jul. 2015
If A is your cell array
c12=A(:,12)
id12=~cellfun(@isnan,c12)
out=A(id12,:)
If you want the part containing nan
out1=A(~id12,:)
5 Kommentare
Azzi Abdelmalek
am 25 Jul. 2015
Bearbeitet: Azzi Abdelmalek
am 25 Jul. 2015
Ok, try this
id12=~cellfun(@(x) all(isnan(x)),c12)
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Structures finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!