Find the closest match values in cell array

Question

Catherine 2017-3-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/329088-find-the-closest-match-values-in-cell-array

评论： Catherine 2017-3-15

Hi guys, I got a cell array and I want to find the index of the array that closest match my defined values. Here is my cell array:

A =
  [565.11,579.965]
  [567.016,581.921]
  [574.162,589.256]
  575.909
  [568.804,583.373]
  [570.197,584.803]
  [566.005,576.676,587.758]

As you can see the length of each row is not the same, that's why I couldn't put it in the form of a normal array. So, if I want to find the index that is the closest match 567.5 and 586.5. How can I do that?

Thanks!

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

请先登录，再进行评论。

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

Answer 1

the cyclist 2017-3-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/329088-find-the-closest-match-values-in-cell-array#answer_258100

在 MATLAB Online 中打开

Here's one way:

A = {
  [565.11,579.965]
  [567.016,581.921]
  [574.162,589.256]
  575.909
  [568.804,583.373]
  [570.197,584.803]
  [566.005,576.676,587.758]};
val = 567.5;
[~,indexToClosestMatch] = min(cellfun(@(x)min(abs(x-val)),A));

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

Image Analyst 2017-3-10

在 MATLAB Online 中打开

So what's wrong with just doing it twice???

val = 567.5;
[~,indexToClosestMatch1] = min(cellfun(@(x)min(abs(x-val)),A));
val = 586.5;
[~,indexToClosestMatch2] = min(cellfun(@(x)min(abs(x-val)),A));

Star Strider 2017-3-10

She’s looking for a row match with an impossible condition.

请先登录，再进行评论。

Answer 2

Star Strider 2017-3-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/329088-find-the-closest-match-values-in-cell-array#answer_258101

在 MATLAB Online 中打开

‘How can I do that?’

One approach:

A = {[565.11,579.965]
      [567.016,581.921]
      [574.162,589.256]
      575.909
      [568.804,583.373]
      [570.197,584.803]
      [566.005,576.676,587.758]};
v = [567.5 586.5];
sz = cellfun(@(x)size(x,2), A, 'Uni',0);                % Calculate Sizes Of Vectors
A_idx = cellfun(@(x)eq(x,2), sz, 'Uni',0);              % Select Only Elements Of ‘A’ With 2 Columns
A_sel = A(cell2mat(A_idx));                             % Elements Of ‘A’ Meeting Criteria
D = pdist2(v,cell2mat(A_sel));                          % Distance Between ‘v’ And Elements Of ‘A’
[~,MinIdx] = min(D);                                    % Indes OF Minimum Distance
A_closest = A_sel{MinIdx}                               % Element Values Of Minimum Distance
A_closest =
        570.2        584.8

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

Star Strider 2017-3-15

No worries. My pleasure.

Catherine 2017-3-15

Hi Star Strider, I am just wondering. Would it be possible, if I find the closest match in the first two columns first and store that information in an array, lets say B. Then go on and find the closest match for the 2nd and 3rd column and store that in array B and find the smallest number of the two to get the information? I don't know if that make sense.

请先登录，再进行评论。