Hi,
To filter rows from the second timetable that occur within a specific time range (e.g., within 2 minutes after the times in the first timetable) without including times before, you can use logical indexing and the "withtol" function in combination with additional conditions.
You can follow the approach as mentioned below to achieve this:
- Use the "withtol" function to get all rows within the tolerance (both before and after the time).
- Filter out the rows that are not within the desired range.
Kindly refer to the following code for your reference:
tol = minutes(2);
%we get a value for boat counts if photo was captured 2 minutes either side
%of hydrophone recording
for a = 1:length(sites)
dBtable = dBcalcs.(sites{a});
counts_subset_rows = contains(boat_counts.Site(:), sites{a});
counts_subset = boat_counts(counts_subset_rows, :);
% Select the times in boat_counts that match detection times with tolerance
tmatch_tt1 = counts_subset(withtol(dBtable.DateTime, tol), :).DateTime;
% Filter out rows that are not within 0 to 2 minutes after the times in dBtable
valid_rows = tmatch_tt1 >= dBtable.DateTime & tmatch_tt1 <= dBtable.DateTime + minutes(2);
tmatch_tt1 = tmatch_tt1(valid_rows);
% Extract rows in boat_counts that are within 2 min of hydrophone recordings
[Lia, Loc] = ismember(tmatch_tt1, counts_subset.DateTime);
counts_subset_new = counts_subset(Loc, :);
% Change detections datetimes to closest datetime of images
% (specific datetime of hydrophone recording remains in spectrogram filename
% of each row)
dBtable = table2timetable(dBtable);
tt2_matched = retime(dBtable, tmatch_tt1, 'nearest');
% Use synchronize to join the matched rows
new_table = synchronize(tt2_matched, counts_subset_new);
new_table.DateTime = datetime(new_table.DateNum, 'ConvertFrom', 'datenum');
dBcalcs_CameraCounts.(sites{a}) = new_table;
end
I hope it will address your query.
Regards,
Zuber
