MATLAB Answers

Index months in timetable

27 views (last 30 days)
Eric Escoto
Eric Escoto on 23 Sep 2020 at 15:52
Commented: Adam Danz on 23 Sep 2020 at 17:03
Is there a command to index months in a timetable series?
I would like to index one long term timetable in two ways. In one, all July, August, and September are indexed. In the second Novemeber through March are indexed.
My timetable is a daily series.

  0 Comments

Sign in to comment.

Accepted Answer

Adam Danz
Adam Danz on 23 Sep 2020 at 16:28
Edited: Adam Danz on 23 Sep 2020 at 16:29
Logical index of rows that are in July,Aug,Sept.
idx = ismember(month(TT2_staLCA_WS.Time),[7,8,9]);

  4 Comments

Show 1 older comment
Adam Danz
Adam Danz on 23 Sep 2020 at 16:40
It's just basic indexing.
For example,
T = table((1:5)',["A";"B";"C";"D";"E"])
% T =
% 5×2 table
% Var1 Var2
% ____ ____
% 1 "A"
% 2 "B"
% 3 "C"
% 4 "D"
% 5 "E"
idx = ismember(T.Var1, [1,3,4]) % rows where var1 is 1,3,or 4
% idx =
% 5×1 logical array
% 1
% 0
% 1
% 1
% 0
% EXAMPLES OF INDEXING
T(idx,:)
% 3×2 table
% Var1 Var2
% ____ ____
% 1 "A"
% 3 "C"
% 4 "D"
T.Var2(idx)
% 3×1 string array
% "A"
% "C"
% "D"
Eric Escoto
Eric Escoto on 23 Sep 2020 at 16:45
Ah of course. Perfect.
Thanks, Adam!
Adam Danz
Adam Danz on 23 Sep 2020 at 17:03
Socially distant high-five!

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by