Delete rows that contains []

10 次查看（过去 30 天）
Alfonso Lopez
Alfonso Lopez 2015-11-25
评论： Alfonso Lopez 2015-11-25
Hi
I would like to delete rows that contains [ ].
Thanks very much.
[ ] 1 NaN
[ ] 1 NaN
[ ] 1 NaN
[ ] 1 NaN
[ ] 1 0
'o_c' 1 1
'w_c' 1 1

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2015-11-25
x = {[ ] 1 NaN
[ ] 1 NaN
[ ] 1 NaN
[ ] 1 NaN
[ ] 1 0
'o_c' 1 1
'w_c' 1 1};
out = x(~any(cellfun(@(x)isempty(x),x),2),:);
  2 个评论
Thorsten
Thorsten 2015-11-25
Or
out = x(~any(cellfun(@isempty,x),2),:)
Alfonso Lopez
Alfonso Lopez 2015-11-25
OMG!! Thanks very much. I was trying to do this almost all morning :)

请先登录，再进行评论。

更多回答（1 个）

Guillaume
Guillaume 2015-11-25
c = {[] 1 NaN
[] 1 NaN
[] 1 NaN
[] 1 NaN
[] 1 0
'o_c' 1 1
'w_c' 1 1};
You get the cells of the cell array that are empty by using isempty on each cell. You can use cellfun to check each cell. You can then use any on each row (2nd dimension) of the cell array to delete rows that have any cell empty:
c(any(cellfun(@isempty, c), 2), :) = []
  1 个评论
Alfonso Lopez
Alfonso Lopez 2015-11-25
The same result as Andrei suggestion. Thanks very much too :)

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by