Delete rows from a subset of rows of a mixed cell array

2 次查看（过去 30 天）
Giovanni Barbarossa
评论： Giovanni Barbarossa 2018-10-6
I have a mixed 6x7 cell array
A = {'text' 12 NaN 14 'text' 16 17; 'text' 0 NaN 24 25 26 27; 31 32 33 34 35 0 'text'; NaN 42 43 44 45 46 0; 51 'text' 53 54 NaN 56 57; 61 62 0 64 65 NaN 67};
How do I delete the rows from 2 to 5 that have one or more cells in columns 3 to 6 equal to NaN or zero? The remaining rows should be rows 1, 4 and 6. Rows 1 and 6 should remain because, even if they have NaNs or zeros in columns 3 to 6, they should not be considered for elimination, and row 4 should remain because it does not have NaNs or zeros in columns 3 to 6. Thanks!
  2 个评论
madhan ravi
madhan ravi 2018-10-5
编辑：madhan ravi 2018-10-5
Just can you type the desired result so that it’s easier to understand the problem?
Giovanni Barbarossa
Giovanni Barbarossa 2018-10-5
The answer should be
B = {'text' 12 NaN 14 'text' 16 17; NaN 42 43 44 45 46 0; 61 62 0 64 65 NaN 67};

请先登录，再进行评论。

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

采纳的回答

Matt J
Matt J 2018-10-5
编辑：Matt J 2018-10-5
keep=~any( cellfun( @(c)isequal(c,0)|isequaln(c,nan) , A(:,3:6) ) , 2);
keep([1,end])=1;
B=A(keep,:)
  6 个评论
显示 4更早的评论
Matt J
Matt J 2018-10-5
编辑：Matt J 2018-10-5
I am not sure why the variable keep increases in size.
Because A(1:end-1,3:6) has more rows than A(2:end-1,3:6). You've given more rows to the middle part of keep but didn't take anything away.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by