MATLAB Answers

Delete rows with NaN for a cell array

조회 수: 145(최근 30일)
Rooy
Rooy 26 Jun 2013
I want to remove the rows that have NaN and still keep the dimension of the array intact.
[ NaN] [ NaN] [ NaN] [ NaN]
[ NaN] [ NaN] [ NaN] [ NaN]
'Total RADIO Drops' 'Total Drops' 'CC DCR (%)' 'RADIO DCR (%)'
Above is just an example, I have over a thousand rows.
The only problem I have now is removing rows which have NaN and string together
Thank you
  댓글 수: 1
Rooy
Rooy 26 Jun 2013
Is there a way to delete the rows which have strings and Nan mixed together ?
[ 'A'] [ NaN] [ NaN] [ NaN]
'Total RADIO Drops' 'Total Drops' 'CC DCR (%)' 'RADIO DCR (%)'

댓글을 달려면 로그인하십시오.

채택된 답변

Tom
Tom 26 Jun 2013
A(any(cellfun(@(x) any(isnan(x)),A),2),:) = [];
  댓글 수: 1
Rooy
Rooy 26 Jun 2013
Thank you, it works

댓글을 달려면 로그인하십시오.

추가 답변(1개)

Andrei Bobrov
Andrei Bobrov 26 Jun 2013
편집: Andrei Bobrov 26 Jun 2013
A - your cell array
out = A(any(cellfun(@(x)any(~isnan(x)),A),2),:);
ADD
out = A(all(cellfun(@(x)any(~isnan(x)),A),2),:);
  댓글 수: 3
Rooy
Rooy 26 Jun 2013
Thank you for your great help

댓글을 달려면 로그인하십시오.

Community Treasure Hunt

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

Start Hunting!

Translated by