i want to delete cells that contain 0's

Question

Ioannis Vourvachakis 2021-11-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1595089-i-want-to-delete-cells-that-contain-0-s

评论： Ioannis Vourvachakis 2021-11-24

采纳的回答： Kevin Holly

In a cell array, there are rows of cells that contain 0's. I want to delete these rows.

Thank you.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Kevin Holly 2021-11-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1595089-i-want-to-delete-cells-that-contain-0-s#answer_839569

Assuming the values in cell array are numeric:

cellarray = {34 , 23, 4, 123, 0 ,423, 4312;34 , 23, 4, 123, 5 ,423, 4312;34 , 0, 0, 123, 5 ,423, 4312;34 , 73, 5, 13, 7 ,23, 43;34 , 22, 3, 125, 5 ,423, 4312}
cellarray = 5×7 cell array
    {[34]}    {[23]}    {[4]}    {[123]}    {[0]}    {[423]}    {[4312]}
    {[34]}    {[23]}    {[4]}    {[123]}    {[5]}    {[423]}    {[4312]}
    {[34]}    {[ 0]}    {[0]}    {[123]}    {[5]}    {[423]}    {[4312]}
    {[34]}    {[73]}    {[5]}    {[ 13]}    {[7]}    {[ 23]}    {[  43]}
    {[34]}    {[22]}    {[3]}    {[125]}    {[5]}    {[423]}    {[4312]}
out = cellfun(@(x) find(x == 0),cellarray,'un',0);
idx = cellfun('isempty',out);
[row, column] = find(~idx);
cellarray(row,:)=[]
cellarray = 3×7 cell array
    {[34]}    {[23]}    {[4]}    {[123]}    {[5]}    {[423]}    {[4312]}
    {[34]}    {[73]}    {[5]}    {[ 13]}    {[7]}    {[ 23]}    {[  43]}
    {[34]}    {[22]}    {[3]}    {[125]}    {[5]}    {[423]}    {[4312]}

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

Kevin Holly 2021-11-24

cellarray = {34 , 23, "ok", 123, 0 ,423, 4312;34 , 23, 4, 123, 5 ,"Words", 4312;34 , 0, 0, 123, 5 ,423, 4312;34 , 73, 5, 13, 7 ,"23", 43;34 , 22, 3, "125", 5 ,423, 4312}
cellarray = 5×7 cell array
    {[34]}    {[23]}    {["ok"]}    {[  123]}    {[0]}    {[    423]}    {[4312]}
    {[34]}    {[23]}    {[   4]}    {[  123]}    {[5]}    {["Words"]}    {[4312]}
    {[34]}    {[ 0]}    {[   0]}    {[  123]}    {[5]}    {[    423]}    {[4312]}
    {[34]}    {[73]}    {[   5]}    {[   13]}    {[7]}    {["23"   ]}    {[  43]}
    {[34]}    {[22]}    {[   3]}    {["125"]}    {[5]}    {[    423]}    {[4312]}
out = cellfun(@(x) isnumeric(x) && x==0 ,cellarray,'un',0)
out = 5×7 cell array
    {[0]}    {[0]}    {[0]}    {[0]}    {[1]}    {[0]}    {[0]}
    {[0]}    {[0]}    {[0]}    {[0]}    {[0]}    {[0]}    {[0]}
    {[0]}    {[1]}    {[1]}    {[0]}    {[0]}    {[0]}    {[0]}
    {[0]}    {[0]}    {[0]}    {[0]}    {[0]}    {[0]}    {[0]}
    {[0]}    {[0]}    {[0]}    {[0]}    {[0]}    {[0]}    {[0]}
 
[row, column] = find(cell2mat(out))
row = 3×1
     3
     3
     1
column = 3×1
     2
     3
     5
cellarray(row,:)=[]
cellarray = 3×7 cell array
    {[34]}    {[23]}    {[4]}    {[  123]}    {[5]}    {["Words"]}    {[4312]}
    {[34]}    {[73]}    {[5]}    {[   13]}    {[7]}    {["23"   ]}    {[  43]}
    {[34]}    {[22]}    {[3]}    {["125"]}    {[5]}    {[    423]}    {[4312]}