How do I determine the closest upcoming index (given a vector of the indices of interest) to each value in a vector of timestamps?

Question

Heidi Hirsh 2020-9-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/593698-how-do-i-determine-the-closest-upcoming-index-given-a-vector-of-the-indices-of-interest-to-each-va

评论： Heidi Hirsh 2020-9-15

data.mat

I have a record of timestamps at 5 minute intervals. I want to calculate the time (ideally in hours) until the next tide change given the indices of the tide changes. I think the first step is to determine the closest upcoming tide change index to each timestamp in the vector (I need to identify the NEXT tide change even if the previous tide change is closer).

I have attached the data here (data.m) where MX (4888x1 double) is my timestamp vector (in matlab time) and flood (32x1 double) identifies the indices of the flood tides starting.

I cannot for the life of me figure out how to translate this problem into Matlab and I'm not sure what to search in the Matlab help section to figure it out either.

Thank you in advance for any help!

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

Adam Danz 2020-9-15

If "MX" are your timestamps and "flood" are the indices of the time stamps that indicate tide-change, then the time of the tide changes are just MX(flood).

Is your goal to compute the time until the next tide change for each of the 4000+ timestamps?

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2020-9-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/593698-how-do-i-determine-the-closest-upcoming-index-given-a-vector-of-the-indices-of-interest-to-each-va#answer_494563

在 MATLAB Online 中打开

tt = vector_of_tide_times;      %must be in increasing order
ts = vector_of_timestamps;      %does not need to be in order
nextidx = interp1(tt, 1:length(tt), ts, 'next');

For each entry in ts, the value of nextidx would be the index into tt at which tt(nextidx(K)) is the next tide time after ts(K)

This is not the only possibility. For example, there are approaches involving

bin = discretize(-ts, fliplr(-tt));
nextidx = length(tt) - bin + 1;

The negatives there are because discretize takes the previous edge not the next edge, and you can map the "next edge" problem to that by taking the negatives of both sides so that the next edge is more negative and so is "previous" in the negative space.

4 个评论
显示 2更早的评论隐藏 2更早的评论

Walter Roberson 2020-9-15

Hmmm... could you show min(flood), max(flood), min(MX), max(MX) ?

Heidi Hirsh 2020-9-15

min(flood) = 6

max(flood) = 4770

min(MX) = 7.3690e+05

max(MX) = 7.3692e+05

min(datetime(datevec(MX))) = 23-Jul-2017 12:00:00

max(datetime(datevec(MX))) = 09-Aug-2017 11:15:00

请先登录，再进行评论。

How do I determine the closest upcoming index (given a vector of the indices of interest) to each value in a vector of timestamps?

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

回答（1 个）

4 个评论
显示 2更早的评论隐藏 2更早的评论

另请参阅

类别

标签

Community Treasure Hunt

How do I determine the closest upcoming index (given a vector of the indices of interest) to each value in a vector of timestamps?

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

回答（1 个）

4 个评论 显示 2更早的评论隐藏 2更早的评论

另请参阅

类别

标签

Community Treasure Hunt

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

4 个评论
显示 2更早的评论隐藏 2更早的评论