How can i Replace missing values from Timetable

25 次查看（过去 30 天）
Ioannis Tsikriteas
评论： Ioannis Tsikriteas 2018-6-9
Hi, i have a Timetable TT1 with a bunch of NaN values on his Data and a second TT2 with the correct values (replacements of NaN's).
How can i replace the Nan value with the correct one at each timestamp?

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

采纳的回答

Paolo
Paolo 2018-6-9
Input timetables:
tt1:
Time Var1
___________ ____
13-Apr-2018 30.1
25-Apr-2018 NaN
26-Apr-2018 12
28-Apr-2018 NaN
tt2:
Time Var1
___________ ____
13-Apr-2018 37.3
25-Apr-2018 41
26-Apr-2018 42.3
28-Apr-2018 55
%Create timetables.
tt1 = timetable(datetime({'13/04/2018';'25/04/2018';'26/04/2018';'28/04/2018'}),[30.1;NaN;12;NaN]);
tt2 = timetable(datetime({'13/04/2018';'25/04/2018';'26/04/2018';'28/04/2018'}), [37.3;41;42.3;55]);
%Find NaN indexes in first timetable.
x = isnan(tt1.Var1);
%Use indexes to replace values in tt1.Var1 with tt2.Var1.
tt1.Var1(x) = tt2.Var1(x);
Output:
Time Var1
___________ ____
13-Apr-2018 30.1
25-Apr-2018 41
26-Apr-2018 12
28-Apr-2018 55
  1 个评论
Ioannis Tsikriteas
Ioannis Tsikriteas 2018-6-9
Yes that definitely solved my problem! Thanks a lot, i had the logical index of the nan values and the last command was what it was misiing

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by