Filter timetable by month

2 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)

Categories

Find more on Interpolation in Help Center and File Exchange

Products


Release

R2021a

Community Treasure Hunt

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

Start Hunting!