How can one create a timetable with one column (all 1) with beginning date and end date?

1 次查看(过去 30 天)
I want to create a timetable T that begins on 1/2/2020 till 5/15/2020. How can one get started?

采纳的回答

Wan Ji
Wan Ji 2021-8-18
I have got your idea and write a code for you:
startdate = datetime('2020-01-02');
enddate = datetime('2020-05-15');
dt = enddate - startdate;
dday = hours(dt)/24 + 1;
TT = timetable('StartTime',startdate,...
'TimeStep',caldays(1), 'size',[dday,3],... % 1 day as time step
'VariableTypes',{'double','double','double'},...
'VariableNames', {'Ones', 'Twos', 'Threes'});
TT.Ones(:) = 1;
TT.Twos(:) = 2;
TT.Threes(:) = 3;
You can see timetable is enough to create such a table but a little bit complex.
TT =
135×3 timetable
Time Ones Twos Threes
__________ ____ ____ ______
2020-01-02 1 2 3
2020-01-03 1 2 3
2020-01-04 1 2 3
2020-01-05 1 2 3
2020-01-06 1 2 3
2020-01-07 1 2 3
...
2020-05-11 1 2 3
2020-05-12 1 2 3
2020-05-13 1 2 3
2020-05-14 1 2 3
2020-05-15 1 2 3
  5 个评论
Wan Ji
Wan Ji 2021-8-18
Ones = [1;1]; t = datetime({'2020-01-02';'2020-05-15'});
TT = retime(timetable(t,Ones),'daily','linear');
This may be more clear

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Time Series Events 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by