search for the position of a number inside a cell (cell with existence of empty rows)

Question

Alberto Acri 2024-2-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2080626-search-for-the-position-of-a-number-inside-a-cell-cell-with-existence-of-empty-rows

回答： Star Strider 2024-2-10

采纳的回答： Star Strider

parameters.mat

在 MATLAB Online 中打开

I am trying to look for each row of 'N' inside a cell.

I am using 'find' but it doesn't seem to work.

I should identify, in the cell, the rows of N. In this case, row 3 and row 19.

parameters = importdata("parameters.mat");
N = [parameters{3,1}; parameters{19,1}];
tt = 1;
    for t = 1:height(parameters)
        [r,c] = find(parameters{t,1}(1,1) == N(tt,1) & ...
                        parameters{t,1}(1,2) == N(tt,2) & ...
                        parameters{t,1}(1,3) == N(tt,3) & ...
                        parameters{t,1}(1,4) == N(tt,4));
       
    end

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2024-2-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2080626-search-for-the-position-of-a-number-inside-a-cell-cell-with-existence-of-empty-rows#answer_1406096

在 MATLAB Online 中打开

parameters.mat

Use ismember (since you have the exact values, otherwise ismembertol) and any (here using the default column orientation, dimension = 1) to be inclusive, with cellfun (that loops internally) —

load('parameters')
% whos
parameters
parameters = 21x1 cell array
    {'parameters'                         }
    {[-23.7557 -202.2222 -189.4345 1.4501]}
    {[-27.2523 -210.5503 -172.2241 1.2088]}
    {0x0 double                           }
    {0x0 double                           }
    {0x0 double                           }
    {0x0 double                           }
    {0x0 double                           }
    {0x0 double                           }
    {0x0 double                           }
    {0x0 double                           }
    {0x0 double                           }
    {0x0 double                           }
    {0x0 double                           }
    {0x0 double                           }
    {0x0 double                           }
N = [parameters{3,1}; parameters{19,1}];                                        % 'Target' Values
idx = cell2mat(cellfun(@(x)any(ismember(x,N)), parameters, 'Unif',0));          % Logical Index Vector
Result_Index = find(idx)                                                        % Numeric Index
Result_Index = 2x1
     3
    19
Result = parameters(idx)                                                        % Result Values
Result = 2x1 cell array
    {[-27.2523 -210.5503 -172.2241 1.2088]}
    {[-31.3830 -213.5605 -165.2437 1.4301]}

There are likely other ways to do this as well.

.

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

请先登录，再进行评论。

Answer 2

VBBV 2024-2-10

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2080626-search-for-the-position-of-a-number-inside-a-cell-cell-with-existence-of-empty-rows#answer_1406031

编辑：VBBV 2024-2-10

Use a | instead of &. OR in place of AND

2 个评论
显示无隐藏无

Alberto Acri 2024-2-10

编辑：Alberto Acri 2024-2-10

I need to know if N(1,:) is inside 'parameters'

VBBV 2024-2-10

在 MATLAB Online 中打开

parameters.mat

Using for loop it can be like this

p = load("parameters.mat");
N = [p.parameters{3,1}; p.parameters{19,1}]
N = 2×4
  -27.2523 -210.5503 -172.2241    1.2088
  -31.3830 -213.5605 -165.2437    1.4301
tt = 1;
    for t = 1:height(p.parameters)-1
        K = p.parameters{t+1,1};
        if ~isempty(K)
            
            if tt == 1  % N(1,:) inside parameter 
                [r,c] = find((K(1) - N(tt,1)) < 1e-3 & ...
                            (K(2) - N(tt,2))  < 1e-3 & ...
                            (K(3) - N(tt,3)) < 1e-3 & ...
                            (K(4) - N(tt,4)) < 1e-3)
            else  % N(2,:) inside parameter 
                tt = tt + 1;
                [r,c] = find((K(1) - N(tt,1)) < 1e-3 & ...
                            (K(2) - N(tt,2))  < 1e-3 & ...
                            (K(3) - N(tt,3)) < 1e-3 & ...
                            (K(4) - N(tt,4)) < 1e-3)
            end 
        end 
       
    end
r =

     []


c =

     []
r = 1
c = 1
r =

     []


c =

     []


r =

     []


c =

     []

You can try using ismember function to vaoid for loop

请先登录，再进行评论。

search for the position of a number inside a cell (cell with existence of empty rows)

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

采纳的回答

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

更多回答（1 个）

2 个评论
显示无隐藏无

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

search for the position of a number inside a cell (cell with existence of empty rows)

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

采纳的回答

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

更多回答（1 个）

2 个评论 显示 无隐藏 无

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

WeChat

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

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

2 个评论
显示无隐藏无