Delete all rows in cell array based on value

6 次查看（过去 30 天）

Jan Kielmann 2019-12-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/497708-delete-all-rows-in-cell-array-based-on-value

评论： J. Alex Lee 2019-12-24

I have a cell array A that contains multiple tables in the first column and add a vector (B) in the second column that shall indicate if a row is used or can be deleted.

A = {table(rand(3,2)); table(rand(3,2)); table(rand(3,2))};

B = {1; 0; 1};

C = horzcat(A,B);

I now have issues to delete all rows in cell array C that are indicated with a 0.

I have tried some proposed solutions for this kind of problem (deleting rows based on value) but could not find a working one for the specific problem.

Has someone an idea how to handle this issue?

Best regards!

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

请先登录，再进行评论。

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

采纳的回答

J. Alex Lee 2019-12-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/497708-delete-all-rows-in-cell-array-based-on-value#answer_407376

在 MATLAB Online 中打开

Do you need the cell array C? Must B be a cell array? If not...

A = {table(rand(3,2)); table(rand(3,2)); table(rand(3,2))};
% make B a logical array
% B = {1; 0; 1};
B = ([1;0;1]);
% don't need C
% C = horzcat(A,B);
A(~B) = [];

If for whatever reason you need an inline solution once you have the cell array C

A = {table(rand(3,2)); table(rand(3,2)); table(rand(3,2))};
B = {1; 0; 1};
C = horzcat(A,B);
C(~C[{:,2}],:)=[]

9 个评论
显示 7更早的评论隐藏 7更早的评论

Veronica Taurino 2019-12-22

Thank you Alex, I was going crazy moving those brackets around ahah neat solution, thank you, I am going to save it for later. Have a nice day

J. Alex Lee 2019-12-24

through browsing more on answers, I found this:

https://www.mathworks.com/help/matlab/matlab_prog/comma-separated-lists.html

Actual documentation about what I was doing with [C{:,2}]

请先登录，再进行评论。

更多回答（1 个）

Veronica Taurino 2019-12-22

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/497708-delete-all-rows-in-cell-array-based-on-value#answer_407375

在 MATLAB Online 中打开

A = {table(rand(3,2)); table(rand(3,2)); table(rand(3,2))};
B = {1; 0; 1};
C = horzcat(A,B);
D={};
ii=0;
jj=0;
for ii=1: size(C,1)
    if C{ii,2}==1
       jj=jj+1;        
       D{jj}=C{ii,1}; 
       D=D';
    end
end