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

3 visualizzazioni (ultimi 30 giorni)
MUKESH KUMAR il 16 Giu 2020
Commentato: Nada Mounir il 28 Feb 2022
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 CommentiMostra 4 commenti meno recentiNascondi 4 commenti meno recenti
Steven Lord il 17 Giu 2020
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)

Accedi per commentare.

### Risposta accettata

Sujay C Sharma il 17 Giu 2020
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:
NumEntriesPerDay = 48;
DataPrevDay = circshift(data,NumEntriesPerDay*1);
DataPrevDay(1:NumEntriesPerDay*1) = NaN;
DataPrevWeek = circshift(data,NumEntriesPerDay*7);
DataPrevWeek(1:NumEntriesPerDay*7) = NaN;
##### 2 CommentiMostra 1 commento meno recenteNascondi 1 commento meno recente
Nada Mounir il 28 Feb 2022
Please it doesn't work for me i have the same problem

Accedi per commentare.

### Categorie

Scopri di più su Spreadsheets in Help Center e File Exchange

### Community Treasure Hunt

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

Start Hunting!

Translated by