Create a timetable that has only the outage durations. Some rows of TT have missing values, NaT, for
the restoration times, leading to NaN values in OutageDuration. To remove the NaN values from
medianTT, use the rmmissing function. Then use retime to calculate the monthly median outage
duration. Display the first five rows of medianTT.
medianTT = TT(:,"OutageDuration");
medianTT = rmmissing(medianTT);
medianTT = retime(medianTT,'monthly',@median);
head(medianTT,5)
ans=5×1 timetable
OutageTime
OutageDuration
________________
______________
2002-02-01 00:00
6.1889 days
2002-03-01 00:00
2.7472 days
2002-04-01 00:00
NaN days
2002-05-01 00:00
0.72917 days
2002-06-01 00:00
0.22431 days
Create a stairstep chart of the monthly median outage durations.
stairs(medianTT.OutageTime,medianTT.OutageDuration)
xlabel("Year")
ylabel("Median Duration (days)")
Select Times in Timetable
10-25