Find rows of cell array containing certain specific multiple cells?

Question

Song Decn 2020-2-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/506981-find-rows-of-cell-array-containing-certain-specific-multiple-cells

编辑： Giuseppe Inghilterra 2020-2-22

采纳的回答： Giuseppe Inghilterra

在 MATLAB Online 中打开

Suppose I have a cell array,

ca = {'a' 'b' 'c' 10 10; 'c' 'e' 'f' 10 20; 'g' 'h' 'i' 20 10;}

How can I find the row containing eg. {'a'} {'b'} {'c'} at same time?

2 个评论
显示无隐藏无

David Hill 2020-2-22

在 MATLAB Online 中打开

What are you trying to do? Does your cell array need to stay the way it is? Why not group the data into matrices with the same data.

ca={['abc';'cef';'ghi'],[10 10;10 20;20 10]};
[idx1,idx2]=find(ca{1}=='a');

Song Decn 2020-2-22

Sorry David, to be clear, I want to find out the row in cell array 'ca', containing {'a'} {'b'} {'c'} at same time.

请先登录，再进行评论。

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

Answer 1

Giuseppe Inghilterra 2020-2-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/506981-find-rows-of-cell-array-containing-certain-specific-multiple-cells#answer_416862

编辑：Giuseppe Inghilterra 2020-2-22

在 MATLAB Online 中打开

Hi,

try to run following code, variable 'r' returns you row that contains what are you looking for:

[r c] = find(strcmp(ca,'g'));

Hope this helps.

Edit:

ValueToFind = {'g' 'h' 'i'}; %Define cell array of values to find in same row
l = length(ValueToFind);
ca = {'a' 'b' 'c' 10 10; 'c' 'e' 'f' 10 20; 'g' 'h' 'i' 20 10;};
[r_ca ~]  = size(ca);
Row = zeros(r_ca,l); 
for ii = 1:l
    [r ~] = find(strcmp(ca,ValueToFind(ii)));
    
    if ~isempty(r)
        r = sort(r);
        Row(r,ii) = 1;
    end
end
r_f = find(all(Row,2));

In this way you obtain the row (r_f) where all ValueToFind are. Right now I give you this solution, by adopting a for loop cycle. I dont think that exists a one-line solution.

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

Song Decn 2020-2-22

Thank u Giuseppe. I want to find out the row in cell array 'ca', containing {'a'} {'b'} {'c'} at same time, not a row containing a single element like 'a' or 'b' or 'g'

请先登录，再进行评论。