MATLAB: Table2timetable adding time vector with start- and end date

table2timetable

From the recording software I"m using, I can export my data only using minutes from a reference point but I would like to convert my data to a timetable.

I know the start date and time and end date and time and tried to create a timetable based on that information:

newTimes = [datetime('2018-07-04 21:40:42'):datetime('2018-07-17 10:02:10')];
TT = table2timetable(tblB,'rowTime',newTimes)

The data was recorded in between this time range in a approx. 5 ms interval resutling in approx. 220000000 data points. Can I interpolate all the datetime/ from start and end time somehow assuming that the data was recorded regularly?

Best Answer

The times for a timetable can be either a datetime array or a duration array. Turn your data into a duration array and use it to build the timetable.

v = (1:5:101).';
data = v.^2;
timevector = seconds(v);
A = timetable(timevector, data)

Related Solutions

MATLAB: Extract data from a timetable excluding an specific date

This should work. Most of these steps should be straightforward..."ismember" may have been the key

tt_1 = timetable(datetime({'13/04/2018';'25/04/2018';'28/04/2018'}), [12;12.5;10]);
tt = timetable(datetime({'13/04/2018';'25/04/2018';'26/04/2018';'28/04/2018'}), [37.3;39.1;42.3;21]);
tt_2_ref = timetable(datetime({'25/04/2018';'26/04/2018'}), [39.1;42.3]);
% find rows in tt_1 satisfying criterion on variable
vflt = tt_1.Var1 < 12.5
% find corresponding dates in tt_1
texcl = tt_1.Time(vflt)
% find rows where times in tt are not in texcl
tflt = ~ismember(tt.Time,texcl)
% extract filtered rows from tt
tt_2 = tt(tflt,:)
% check against ref
isequal(tt_2,tt_2_ref)

MATLAB: How to arrenge timeseries data

use sort?

 [~,indx] = sort(data(:,1));
 sortedData = data(indx,:);

Best Answer

Related Solutions

MATLAB: Extract data from a timetable excluding an specific date

MATLAB: How to arrenge timeseries data

Related Question