Match datetime within 2 seconds from two columns of different sizes

3 次查看（过去 30 天）
Alejandro Sanz
Alejandro Sanz 2021-6-14
编辑： Aghamarsh Varanasi 2021-6-17
Hi all,
I am trying to match datetimes to an accuracy of within 2 seconds of two columns of different sizes. I want to compare all the elements of one datetime column (this column has 3465 elements) with all the elements of the other datetime column (2450 elements) and create one variable with the elements of the first column which differ less than 2 minutes from any element of the 2nd column, and other variable with the elements of the 2nd column whitch differ less than 2 minutes from any element of 1st column.
The 2 columns have the format 'MM/dd/yyyy HH:mm:ss,
In the end my goal is to make a graphic with the datetime and other variable and to represent the dates that are very similar (less than 2 minutes), so I can compare how the other variable is behaving in the same dates.

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

回答（1 个）

Aghamarsh Varanasi
Aghamarsh Varanasi 2021-6-17
编辑：Aghamarsh Varanasi 2021-6-17
Hi,
To handle datetime data, you can use the datetime data type to save the data as a MATLAB variable. This helps you to compare two dates as follows:
d1 = '06/17/2021 10:30:05';
d2 = '06/17/2021 10:35:15';
date1 = datetime(d1, 'InputFormat', 'MM/dd/yyyy HH:mm:ss');
date2 = datetime(d2, 'InputFormat', 'MM/dd/yyyy HH:mm:ss');
var = [];
% check if the duration difference is less than 2 minutes
if date1.Minute < date2.Minute + 2 && date1.Minute > date2.Minute - 2
var = [var, [date1, date2]];
end
You can convert the columns into datetime arrays and run a for loop to compare each data point. For more information on Date and Time data types refer to this documentation page.

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by