Can someone provide the syntax for selecting monthly rowtimes from a timeteble? I would like to select various months. For example, Nov., Dec., Jan., Feb.
Here is what I'm trying:
The 'wintertime' variable and the follwing lines are also screwed up.
Thanks.
% Create new timetables at differing scales.
% Extract the month record
monthofTT = month(TT.Time);
% Determine which records are between November and March (months 1:3 and
% 11:12)
wintertime = [1,3;11,12]; % [start, end] of desired months
wintermonths = monthofTT >= winter(1) & wintertime <= winter(2);
% Isolate all row in winter months
TTwinter = TT(month(TT.Time(winterrmonths)), :);

 Respuesta aceptada

dpb
dpb el 23 de Sept. de 2021
Editada: dpb el 24 de Sept. de 2021
To use the numeric months,
wintertime = [1:3 11:12]; % [start, end] of desired months
TTwinter = TT(ismember(month(TT.Time),wintertime), :);

6 comentarios

Hi dpb,
I tried this. Got an error.
Error using matlab.internal.datatypes.getChoice (line 77)
Month type must be 'monthofyear', 'name', or 'shortname'.
Error in datetime/month (line 1090)
kind = getChoice(kind,["MonthOfYear" "MoY" "Name" "LongName" "ShortName"],[1 1 2 2 3], ...
dpb
dpb el 24 de Sept. de 2021
Well, without your actual time table, I just used the variable name you gave; it's unknowable w/o the actual table just what you had/have done.
Attach it as a .mat file...
Eric Escoto
Eric Escoto el 24 de Sept. de 2021
Sure thing.
dpb
dpb el 24 de Sept. de 2021
My eyes got crossed last night -- it'd been a long day working on scholarship billings for the local nonprofit college foundation already by that time...there's a misplaced parenthesis in the original. It's at the end of the ismember argument list and is missing one to close the argument to month().
Corrected above. Tested here, works fine...
Eric Escoto
Eric Escoto el 24 de Sept. de 2021
Ah I see it. Thanks!
dpb
dpb el 25 de Sept. de 2021
Was pretty obvious when not so tired...sorry didn't catch it at first.

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Productos

Versión

R2021b

Etiquetas

Preguntada:

el 23 de Sept. de 2021

Comentada:

dpb
el 25 de Sept. de 2021

Community Treasure Hunt

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

Start Hunting!

Translated by