How do I adjust this loop to the minute level?

3 次查看（过去 30 天）

Fatemah Ebrahim 2020-5-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524542-how-do-i-adjust-this-loop-to-the-minute-level

评论： Fatemah Ebrahim 2020-5-11

So I have part of my code below running through a large Excel sheet of timeseries data to differentiate between average hourly weekend and weekday consumption by pulling the unique hour. I now want to run this again but incorporate the minutes along with the hours. I tried several different ways but to no prevail. Any help would be much appreciated.

for i = 1:length(UniqueTimeSteps)
HourValue(i) = UniqueTimeSteps(i);
[TimeValue,MinValue,Seconds] = hms(UniqueTimeSteps(i));
idx = (t.Hour == TimeValue & weekday(t) > 1 & weekday(t) < 7);
Consumption_Weekday(i) = mean(AptA(idx));
idx = (t.Hour == TimeValue & (weekday(t) == 1 | weekday(t) == 7));
Consumption_Weekend(i) = mean(AptA(idx));
end

3 个评论
显示 1更早的评论隐藏 1更早的评论

Fatemah Ebrahim 2020-5-11

The issue I'm having is with the hour and minute, with the code I have now I can do either or but not the two together.

Fatemah Ebrahim 2020-5-11

在 MATLAB Online 中打开

I tried running this code:

for i = 1:length(UniqueTimeSteps)
TimeValue(i) = UniqueTimeSteps(i);
[HourValue,MinValue,Seconds] = hms(UniqueTimeSteps(i));
idx = (t.Hour + t.Minute == HourValue & MinValue & weekday(t) > 1 & weekday(t) < 7);
Consumption_Weekday(i) = mean(A(idx));
idx = (t.Hour + t.Minute == HourValue & MinValue & (weekday(t) == 1 | weekday(t) == 7));
Consumption_Weekend(i) = mean(A(idx));
end
figureA = figure;
plot(TimeValue,Consumption_Weekday,'-*b');
hold on
plot(TimeValue,Consumption_Weekend,'--r');