Filter timetable by month

13 views (last 30 days)
Mark Maders
Mark Maders on 5 Aug 2021
Commented: Mark Maders on 5 Aug 2021
I have the following code that filters a timetable to show only rows in January
T_Departures_Jan = T_Departures.Date_Time(timerange('01/01/2020', 'months'),:);
T_Departures_Jan = T_Departures(T_Departures_Jan,:);
Jan_KWH = sum(T_Departures_Jan.AircraftKWH);
Is there a way to do this without giving a solid start date? I don't want this to be 2020 exclusive - I wish to be able to apply the code to previous/future year sets of input data.

Accepted Answer

Chunru
Chunru on 5 Aug 2021
Edited: Chunru on 5 Aug 2021
%T_Departures_Jan = T_Departures.Date_Time(timerange('01/01/2020', 'months'),:);
T_Departures_Jan = T_Departures(month(T_Departures.Date_Time) == 1,:);
Jan_KWH = sum(T_Departures_Jan.AircraftKWH);

More Answers (0)

Products


Release

R2021a

Community Treasure Hunt

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

Start Hunting!