How to find the nearest matrix between two matrices?

1 次查看（过去 30 天）
MP
MP 2022-7-18
评论： MP 2022-7-19
Find the nearest row matching between matrix.
I have a matrix
A = [2013 03 17 1 6 0]; % 1x6 double
I have another matrix
B = [2013 3 17 0 5 1.012; 2013 3 17 1 6 20.47]; % 4x6 double
I want to find the index of the nearest matrix A in B.
Can anyone please help?
Any help will be greatly appriciated.

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

采纳的回答

Rik
Rik 2022-7-18
Convert each row to a date format (either datetime or datenum).
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 个评论
Stephen23
Stephen23 2022-7-18
编辑：Stephen23 2022-7-18
Ran in:
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

请先登录，再进行评论。

更多回答（1 个）

Abderrahim. B
Abderrahim. B 2022-7-18
编辑：Abderrahim. B 2022-7-18
Ran in:
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
  5 个评论
显示 3更早的评论
Rik
Rik 2022-7-18
@MP did you see my answer? Stephen already implemented it for you in a comment.
MP
MP 2022-7-19
Yes, @Rik, thanks for helping. I was trying how to implement it but @Stephen23's comment did a great help.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Function Creation 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by