MATLAB: How to merge multiple timetable

mergeordertimetable

dear advisers,

i have multiple timetables with different timestamps (yyyy-mm-dd hh:mm), but within a same time period.

I wish to merge multiple timetables into a single timetable, and the measurement recorded for each corresponding timestamps shall be organized in ascending order (e.g. 2020-08-01 0:00 , 2008-08-01 1:00, ….).

Thank you for your advice.

Best Answer

You might be able to use synchronize. If you have more than 2 tables, you will need to use it multiple times.

Related Solutions

MATLAB: Convert date to datetime

t = datetime(DateStrings,'InputFormat','dd/MM/yyyy');

MATLAB: Subtractions between consecutive rows in a table

Deyire, unless you're using a pretty old version of MATLAB, use datetime and duration instead of datestr/datenum/datevec. Also your code doesn't look like it computes time differences, it computes milliseconds since year zero. Try this:

>> t0 = datetime('now'); pause(rand); t1 = datetime('now'); >> milliseconds(t1 - t0) ans = 453.54

I suggest that in your loop, you save all the timestamps, as datetimes, and all the data at each timestamp, and then ONCE, outside the loop, create a timetable something like this:

dt = diff(timestamps); dt.Format = 's';
tt = timetable(data(2:end),'RowTimes',dt)

Best Answer

Related Solutions

MATLAB: Convert date to datetime

MATLAB: Subtractions between consecutive rows in a table

Related Question