MATLAB Programming Fundamentals - MathWorks

NorthEast energy emergency 11638 1.4391e+05

NorthEast equipment fault 794.36 3.9961e+05

NorthEast fire 872.96 6.1292e+05

NorthEast severe storm 6002.4 2.7905e+07

NorthEast thunder storm 23418 2.1885e+07

Calculate Mean Durations of Power Outages

Determine the mean durations of all U.S. power outages in hours. Add the mean durations

of power outages to powerLosses. Because T.RestorationTime has NaT values, omit

the resulting NaN values when calculating the mean durations.

D = T.RestorationTime - T.OutageTime;

H = hours(D);

omeanFcn = @(x)(mean(x,'omitnan'));

powerLosses.meanOutage = splitapply(omeanFcn,H,G);

powerLosses(1:15,:)

ans=15×5 table

Region Cause maxLoss totalCustomers meanOutage

_________ ________________ _______ ______________ __________

MidWest attack 0 0 335.02

MidWest energy emergency 2378.7 6.3363e+05 5339.3

MidWest equipment fault 903.28 1.7822e+05 17.863

MidWest severe storm 6808.7 1.3511e+07 78.906

MidWest thunder storm 15128 4.2563e+06 51.245

MidWest unknown 23141 3.9505e+06 30.892

MidWest wind 2053.8 1.8796e+06 73.761

MidWest winter storm 669.25 4.8887e+06 127.58

NorthEast attack 405.62 2181.8 5.5117

NorthEast earthquake 0 0 0

NorthEast energy emergency 11638 1.4391e+05 77.345

NorthEast equipment fault 794.36 3.9961e+05 87.204

NorthEast fire 872.96 6.1292e+05 4.0267

NorthEast severe storm 6002.4 2.7905e+07 2163.5

NorthEast thunder storm 23418 2.1885e+07 46.098

See Also

findgroups | rowfun | splitapply | varfun

9 Tables