MATLAB: How to find the index or entry with respect to date and time in a time-series data

datadataimportMATLABtime series

Hi, I have a time-series data and I want to find entries closest to e.g. 13-March-2018 24:00:00. Could you help me here?

Best Answer

I found the answer. I converted the dates in numbers using datenum. It works now.

Related Solutions

MATLAB: Correlate time-series

You can use vq = interp1(x,v,xq) to interpolate the temp data so that it has 160 values. Then use R = corrcoef(A,B) to compute the correlation coefficient between the two time series. If one time series is shifted relative to the other, you may want to consider the cross correlation to measure the lag: r = xcorr(x,y).

MATLAB: Time-series data

The 'simplest' way to do a series of mean values is to use a for loop with the mean function.

nmean = 50; % Number of values you would like to average at a time
for i = 1:2*length(data)/nmean
    average(i) = mean(data((i-1)*nmean/2:(i-1)*nmean/2+nmean));
end

You may run into an issue with index exceeding matrix dimensions near the end of your data set. If this happens, just reduce the maximum i value by changing the bounds of the loop. If you are not sure how to do that look up the basics of a for loop here.

Best Answer

Related Solutions

MATLAB: Correlate time-series

MATLAB: Time-series data

Related Question