Finding Closest Data Point

Question

Krispy Scripts 2016-10-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/309120-finding-closest-data-point

评论： Image Analyst 2016-10-26

I have one matrix with data in the first column and time stamps in the second column (datamatrix.mat). The next matrix contains spiketimes (spiketimematrix.mat). I want to get the data point in the first column of first matrix that is the closest time point corresponding to the spike times in spiketimematrix.mat. For example, the first spiketime is 166.1670, which corresponds to the closet time point of 166.1696 and corresponds with the data point 2.5281.

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

请先登录，再进行评论。

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

Answer 1

Image Analyst 2016-10-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/309120-finding-closest-data-point#answer_240665

在 MATLAB Online 中打开

Try something like

% Find all time differences:
timeDiffs = abs(timeStamps - spikeTimes);
% Find out which has the smallest difference:
[minTimeDiff, indexOfMin] = min(timeDiffs);
% Get the value from column 1.
result = dataColumn1(indexOfMin)

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

Krispy Scripts 2016-10-25

Would this be simpler if instead of getting the closest, I got the one greater than or equal to?

Image Analyst 2016-10-26

在 MATLAB Online 中打开

Sorry - that's what I get for tossing something off the top of my head and not actually testing it. Ignore that code (I'll delete it) and use this instead:

numPoints1 = 6;
timeStamps = rand(numPoints1, 1) % Sample data.
numPoints2 = 3;
spikeTimes = rand(numPoints2, 1) % Sample data.
t1 = [timeStamps, zeros(length(timeStamps), 1)];
t2 = [spikeTimes, zeros(length(spikeTimes), 1)];
distances = pdist2(t1, t2)
minDistance = min(distances(distances>0))
[row, column] = find(distances == minDistance)
fprintf('The minimum time difference is %f and goes between\n   timeStamp(%d) = %f, and\n   spikeTimes(%d) = %f\n',...
  minDistance, row, timeStamps(row), column, spikeTimes(column));