how to extract previous week and month number of same hour?

2 次查看（过去 30 天）

MUKESH KUMAR 2020-6-16

2
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/549021-how-to-extract-previous-week-and-month-number-of-same-hour

评论： Nada Mounir 2022-2-28

I had load data of one year, half houly data of load (1*17520), I want to add a column having load data of previous week (same day & time period) and another column having previous day data at same time slot

We can keep blank for initial week/day data because for that previous data is not available here.

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

MUKESH KUMAR 2020-6-16

Book1.xlsx

Ok sure

Steven Lord 2020-6-17

在 MATLAB Online 中打开

KSSV: if MUKESH KUMAR has the date and time data stored as a datetime array or as the time vector in a timetable, there's no need to split that data to jump backwards a day or a week.

d = datetime('now')
dMinusWeek = d - calweeks(1)
dMinusDay = d - caldays(1)

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Sujay C Sharma 2020-6-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/549021-how-to-extract-previous-week-and-month-number-of-same-hour#answer_452598

在 MATLAB Online 中打开

Hi,

Since the number of load entries per day is fixed at 48 (half-hourly data), this can be done using the circshift function on the load column in your data. Here is an example of how you can use circshift to achieve what you want:

X = readtable('Book1.xlsx');
NumEntriesPerDay = 48;
Data = X.load;
DataPrevDay = circshift(data,NumEntriesPerDay*1);
DataPrevDay(1:NumEntriesPerDay*1) = NaN;
DataPrevWeek = circshift(data,NumEntriesPerDay*7);
DataPrevWeek(1:NumEntriesPerDay*7) = NaN;
X.PreDayload = DataPrevDay;
X.PrevWeekLoad = DataPrevWeek;