How to find the nearest matrix between two matrices?

After that you can subtract one from the other, use abs and min to find the smallest difference. Use the second output of min to find the index of the smallest difference.

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

Stephen23 2022-7-18

编辑：Stephen23 2022-7-18

A = [2013,3,17,1,6,0]; % 1x6 double
B = [2013,3,17,0,5,1.012; 2013,3,17,1,6,20.47]; % 4x6 double

The best way of storing timestamps is as DATETIME objects:

Adt = datetime(A)
Adt = datetime
   17-Mar-2013 01:06:00
Bdt = datetime(B)
Bdt = 2×1 datetime array
   17-Mar-2013 00:05:01
   17-Mar-2013 01:06:20

Then just use ABS and MIN exactly as Rik recommended:

[~,idx] = min(abs(Adt-Bdt))
idx = 2
Bdt(idx)
ans = datetime
   17-Mar-2013 01:06:20

请先登录，再进行评论。

Answer 2

Abderrahim. B 2022-7-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1762535-how-to-find-the-nearest-matrix-between-two-matrices#answer_1009625

编辑：Abderrahim. B 2022-7-18

clear
A = [2013,3,17,1,6,0]; % 1x6 double
B = [2013,3,17,0,5,1.012; 2013,3,17,1,6,20.47]; % 4x6 double
A = datetime(A) ;
B = datetime(B) ;
minSize_B = max(size(B)) ;
nearestAB  = [] ;
for ii = 1:minSize_B
    nearestAB = [nearestAB abs(A - B(ii))] ;
end
[~, nearestB_indx] = min(nearestAB) % Means, the 4th row in B
nearestB_indx = 2
nearestB = B(nearestB_indx)
nearestB = datetime
   17-Mar-2013 01:06:20