How can I delete the rows if they have a NaN value?

Hello all,

My problem is kinda cheezy but I still can't solve the problem so here it is;

So my codes I wrote so far are;

load carsmall
x=[MPG]
y=[Weight]

and I'd likte to delete the rows which contains NaN in my x value. Long story in short I'd like to delete the rows 11,12,13,14,15 and 18 since they have NaN values.

Any helps are appreciated,

Regards,

Answer 1

[Matt J]

keep=~isnan(x);

x=x(keep);
y=y(keep);

[Emre Eryigit]

It didn't work unfortunately. My NaN values are still there and they need to be deleted.

[Matt J]

Works fine for me:

load carsmall
x=[MPG];
y=[Weight];

keep=~isnan(x);

x=x(keep);
y=y(keep);

tf=any(isnan(x))

tf = logical
   0

[Emre Eryigit]

Okay now it's solved thanks a lot! :)

[Matt J]

You're welcome, but please Accept-click the answer to indicate that it addressed your question.

Answer 2

[Khalid Mahmood]

Let Matrix A has NaN values, we want a matrix B which contains all rows of A except which have NaN values

function testNaNRemoval()
A = [  1   5   8 ;   -3 NaN  14;0   6 NaN ; 1   5   18];
B=remove_nan_rows(A)
end
function B = remove_nan_rows(A)
  B=[];ib=1;
  for i=1:size(A,1)
      if any(isnan(A(i,:))), continue;end
      B(ib,:)=A(i,:); ib=ib+1;
  end
end

[Khalid Mahmood]

This is a bit lengthy answer, but keep=~isnan(A); B=A(keep) also works.

Advantage of longer method is when we want mixed behaviour or our tailored processing