Calculate the rate of change from 5 minutes interval

14 次查看（过去 30 天）
Ann
Ann 2021-1-7
评论： Mathieu NOE 2023-11-27
Good day, everyone.
As attached is my observations data for 24 hours from different transmitter (PRN) . The data here are from 1/1/2014 to 31/1/2014. From the excel (refer attachment), I already extracted 1-minute average for all PRN in 31 days via the code below.
My problem now is how to calculate the rate of change per 5 minute from data in PRNTT1min. Already done on step 6 on managing time series for 5-mins resampling but I couldn't figure out to find the rate of change. May be the answer is already there but I am completely lost now.
Thank you in advanced.
%_______________1- Read data_______________%
data = readtable("Book_Jan.xlsx");
%___2- Convert DAY and TIME into durations___%
data.DAY = days(data.DAY);
data.TIME = days(data.TIME);
%___3- Create a datetime___%
data.TimeStamp = datetime(2014,01,01) + data.DAY-1 + data.TIME;
data.TimeStamp.Format = "MM-dd-yy HH:mm";
%___4- Convert the table to a timetable___%
dataTT = table2timetable(data,"RowTimes","TimeStamp");
%___5- Use retime to average the PRN data into 1 minute increments___%
PRNTT1min = retime(dataTT(:,["VTEC" "S4" "Sigma"]),"minutely","mean");
%___6- Round time to nearest 5 min and take unique values only___%
tt = data.TimeStamp;
tt.Minute = 5 * floor(tt.Minute/5); %5 means for 5 mins resampling
tt.Second = 0;
NEWTIMESTEP = unique(tt);
%%%%%___PROBLEM HERE___%%%%%
%___7- Find rate of change of VTEC, S4, Sigma for 5 mins___%
%%%%%___NEED HELP HERE TOO___%%%%%

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

采纳的回答

Mathieu NOE
Mathieu NOE 2021-1-7
hello Ann
welcome back !
here the end of the code , I don't know if the rate is per second or per minute, you to decide
%___Use retime to average the data into 5 minute increments___%
dataTT5min = retime(dataTT(:,["VTEC" "S4" "Sigma"]),"regular","mean","TimeStep",minutes(5));
%___7- Find rate of change of VTEC, S4, Sigma for 5 mins___%
all_data = table2array(dataTT5min);
rate_per_seconds = diff(all_data)/(5*60);
rate_per_minute = diff(all_data)/5;
  6 个评论
显示 4更早的评论
Mathieu NOE
Mathieu NOE 2021-1-8
Glad I could be of some help !!
good luck for the future !

请先登录，再进行评论。

更多回答（1 个）

Jason
Jason 2023-11-26
how to prove in matlab: fA spherical iron ball 8 inches diameter is coated with a layer of ice of uniform thickness. If the ice melts at a rate of 14 inches3/minute, how fast is the thickness of the ice decreasing when it is 2 in.​ thick?

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by