Delete Rows With empty elements

2 次查看（过去 30 天）

显示更早的评论

T 2013-8-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/85118-delete-rows-with-empty-elements

采纳的回答： Azzi Abdelmalek

在 MATLAB Online 中打开

Suppose I have a set of data (a 2x9 matrix):

data2 =

   [ 1] [0.0095]  [5670000]    [936]    'Normal'    [0]    [0]   [0] [    NaN]
   [ 2] [0.0095]  [5670000]    [936]    'Normal'    [0]    [0]   [0] [    NaN]
   [ 3] [0.0095]  [5670000]    [936]    'Normal'    [0]    [0]   [0] [    NaN]
   [ 4] [0.0095]  [5670000]    [936]    'Normal'    [0]    [0]   [0]    'some text'
   [ 5] [0.0095]  [5670000]    [936]    'Normal'    [0]    [0]   [0]    'some text'

I want to be able to detect the NaN's and delete the first three columns.

Typically this is done through

 data1(find(sum(isnan(data2),2)==0),:)
but isnan is for input arguements of type 'cell'. What else can I try?

2 个评论
显示无隐藏无

Azzi Abdelmalek 2013-8-19

Do you want to delete just 3 rows?

T 2013-8-19

Yes.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Azzi Abdelmalek 2013-8-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/85118-delete-rows-with-empty-elements#answer_94623

在 MATLAB Online 中打开

data1(any(cellfun(@(x) any(isnan(x)),data1),2),:)=[]

3 个评论
显示 1更早的评论隐藏 1更早的评论

Azzi Abdelmalek 2013-8-19

编辑：Azzi Abdelmalek 2013-8-19

Why have you changed data1? this has nothing to do with your question

T 2013-8-19

Sorry, the original post should have read data2.

请先登录，再进行评论。

类别

MATLAB Language Fundamentals Data Types Numeric Types Logical

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by