how to match the date ? and set a flag ?

3 次查看（过去 30 天）
pruth
pruth 2020-7-6
回答： pruth 2020-7-6
I have created two mat files ! (attached)
I am finding nearest date and correspoding cell (from interpolated_radiosonde ) to mat_data_time dates.
  1. TT_out gives what exactly what i want. but additionally i also want to create another vector that will tell me the which date (from interpolated_radiosonde) it has chosen as nearest date.
  2. . The code below finds the nearest date but it doesn't tell how much nearest it is ! i want to add some syntax to this code which will create another timetable/mat file and give the list of dates which has gap more than 12 hours(or any number of hours I set).
any help will be appriciated. thank you.
load 'mat_data_time.mat'
load('interpolated_radiosonde.mat')
mat_data_time = datetime((mat_data_time(1,:))','ConvertFrom','datenum'); %selecting one time from the scan
T = timetable(interpolated_radiosonde(:,2),'RowTimes',datetime(interpolated_radiosonde(:,1),'ConvertFrom','datenum'));
TT_out = retime(T,mat_data_time,'nearest');
  1 个评论
pruth
pruth 2020-7-6
first question solved.
just had to add
T.Var2 = T.Time
before retime.
it gives me third vector in TT_out of matched data.

请先登录，再进行评论。

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

采纳的回答

pruth
pruth 2020-7-6
load('interpolated_radiosonde.mat')
mat_data_time = datetime((mat_data_time(1,:))','ConvertFrom','datenum'); %selecting one time from the scan
T = timetable(interpolated_radiosonde(:,2),'RowTimes',datetime(interpolated_radiosonde(:,1),'ConvertFrom','datenum'));
T.Var2 = T.Time ;
TT_out = retime(T,mat_data_time,'nearest');
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%% to find flagg dates %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
thurshold_hour = hours(6) ;
for i = 1:size(TT_out)
if abs((TT_out.Time(i)-TT_out.Var2(i)))> thurshold_hour
TD(i) = TT_out.Time(i).';
end
end
TD = TD.';
flg_dates = ismissing(TD);
flagged_dates = TD(~flg_dates,:);
flagged_dates_difference = hours(TT_out.Time(:)-TT_out.Var2(:));

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by