I currently have a timetable where I have a time column and a latitude column. Where:
Time=[t1,t2,t3,t4,t5,t6,t7] Latitude=[l1,Nan,l2,Nan,l3,Nan,l4]
How do I interpolate the Nan values in the latitude column by using the time column?
MATLAB: Interpolatation between values in a timetable
fillmissinginterpolationtimetable
Related Solutions
One simple way to combine these variables is to add them together in a new timetable variable and delete the old variables.
For example, assuming the table looks something like this,
>> baz = synchronize(t1,t2)baz = 9×8 timetable UTC Freq_t1 FreqErr_t1 Vpk_t1 dBV_Vpk__t1 Freq_t2 FreqErr_t2 Vpk_t2 dBV_Vpk__t2 ____________________ _______ __________ ______ ___________ _______ __________ ______ ___________ 01-Jan-2020 00:00:00 9 10 8 4 4 NaN 3 2 01-Jan-2020 06:00:00 NaN 2 10 7 8 7 8 3 01-Jan-2020 12:00:00 2 NaN 7 2 8 7 3 NaN 01-Jan-2020 18:00:00 10 10 1 8 2 NaN 6 3 02-Jan-2020 00:00:00 7 5 9 1 5 2 NaN 9 02-Jan-2020 06:00:00 1 9 10 3 5 5 9 3 02-Jan-2020 12:00:00 3 NaN 7 1 7 10 10 10 02-Jan-2020 18:00:00 6 5 NaN NaN 8 4 6 4 03-Jan-2020 00:00:00 10 10 8 9 8 NaN 2 2 we can do
>> baz.FreqErr = sum([baz.FreqErr_t1 baz.FreqErr_t2],2,"omitnan");>> baz = removevars(baz,["FreqErr_t1","FreqErr_t2"])baz = 9×7 timetable UTC Freq_t1 Vpk_t1 dBV_Vpk__t1 Freq_t2 Vpk_t2 dBV_Vpk__t2 FreqErr ____________________ _______ ______ ___________ _______ ______ ___________ _______ 01-Jan-2020 00:00:00 9 8 4 4 3 2 10 01-Jan-2020 06:00:00 NaN 10 7 8 8 3 9 01-Jan-2020 12:00:00 2 7 2 8 3 NaN 7 01-Jan-2020 18:00:00 10 1 8 2 6 3 10 02-Jan-2020 00:00:00 7 9 1 5 NaN 9 7 02-Jan-2020 06:00:00 1 10 3 5 9 3 14 02-Jan-2020 12:00:00 3 7 1 7 10 10 10 02-Jan-2020 18:00:00 6 NaN NaN 8 6 4 9 03-Jan-2020 00:00:00 10 8 9 8 2 2 10 Really this is best done with fillmissing. It's just two lines:
>> X = [1;2;-3;-4;5;6];>> tt = timetable(X,'RowTimes',datetime(2018,12,27,0,0:5,0))tt = 6×1 timetable Time X ____________________ __ 27-Dec-2018 00:00:00 1 27-Dec-2018 00:01:00 2 27-Dec-2018 00:02:00 -3 27-Dec-2018 00:03:00 -4 27-Dec-2018 00:04:00 5 27-Dec-2018 00:05:00 6>> tt.X(tt.X<0) = NaNtt = 6×1 timetable Time X ____________________ ___ 27-Dec-2018 00:00:00 1 27-Dec-2018 00:01:00 2 27-Dec-2018 00:02:00 NaN 27-Dec-2018 00:03:00 NaN 27-Dec-2018 00:04:00 5 27-Dec-2018 00:05:00 6>> tt1 = fillmissing(tt,"spline")tt1 = 6×1 timetable Time X ____________________ _ 27-Dec-2018 00:00:00 1 27-Dec-2018 00:01:00 2 27-Dec-2018 00:02:00 3 27-Dec-2018 00:03:00 4 27-Dec-2018 00:04:00 5 27-Dec-2018 00:05:00 6
Best Answer