there is nan in a column, delete the whole row

I have a data base called data_crsp, and there might be some nan values in c.lagpe column (column 18), I want the whole row of data to be romoved if there is nan in column 18.

Thanks in advance!

[the cyclist]

I'm confused, because you refer to a "data base" data_crsp, but that's not a MATLAB object type.Then you refer to c.lagpe, but it's not clear what c is.

[Walter Roberson]

rmmissing

Answer 1

[Chunru]

idx = isnan(c.lagpe);       % find the index of nan
c(idx, :) =[];              % remove the rows from table