how to find nearest date corresponding value ?

26 views (last 30 days)
pruth
pruth on 17 Oct 2019
Commented: pruth on 17 Oct 2019
Hi, i am really stuck here and can not move ahead !
i have written this code to match the date which works fine as expected.
load('date.mat ');
load('AOD.mat ');
N = AOD_440(:,1);
V = A(:,1);
B = repmat(N,[1 length(V)])
[minValue,closestIndex] = min(abs(B-V'));
closestValue = N(closestIndex);
but here AOD_440 has second column which has some values. so when above code is finding its closest date it should put the corresponding value in second column !
how can we just update the above code ?
or do I need to write different method code ?
i hope you understand the question !
  2 Comments
pruth
pruth on 17 Oct 2019
Thats works fine too !! thanks !

Sign in to comment.

Accepted Answer

Jos (10584)
Jos (10584) on 17 Oct 2019
Does this return what you want?
R = AOD_440(closestIndex, [1 2]) % select first (date?) and second (values?) columns

More Answers (0)

Community Treasure Hunt

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

Start Hunting!