Associate value to the correct date

6 次查看（过去 30 天）
Francesco Panico
Francesco Panico 2019-3-2
回答： Eric Sofen 2019-3-3
Hi, I have 4 lists
1st ,2nd and 3rd -> composed by column : Date and Value (some date missing)
4th --> a coloumn of the complete list of date
I'd like to obtain a matrix made by the column : Date (complete, from 4th) , Value1, Value2, Value3. Each value mast be associated correctly to it's date. When a value for a date is absent , write NaN.
How can I do ? thanks for your answer.
Example : matlab.png

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

采纳的回答

Eric Sofen
Eric Sofen 2019-3-3
Take a look at the timetable synchronize method. If you import your "1st", "2nd", "3rd" as separate timetables tt1,tt2,tt3, then you can do:
tt = synchronize(tt1,tt2,tt3,'regular','TimeStep',dt)
The default method for filling in time when there's no data is 'fillwithmissing', which i what you want.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Time Series Objects 的更多信息

标签

产品


版本

R2014b

Community Treasure Hunt

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

Start Hunting!

Translated by