how i do loop over column?
显示 更早的评论
hi all,
I have a matrix with the dim of 978 * 744 which I want to loop over a number of a column with time step equal to 168 (hr/week) to have the final matrices of each week separately with the same number of rows 978
could anyone help me with, please?
thank you in advance.
采纳的回答
If you want to do time-based calculation with your data, for example, weekly average or something I'd highly recommend using timetables (version 16b and above). Even for versions a bit older than that, use tables with datevec and then varfun.
5 个评论
Lilya
2017-12-15
Guillaume
2017-12-15
@KL, I would use datetime which is a lot more powerful than datevec.
@Lina, with timetables you can calculate, weekly, monthly, hourtly, quaterly, etc. anything, not just mean. One thing for sure, you do not want to split weeks in separate matrices. Whatever it is you're trying to do, it will be harder once you've split your original data into several matrices.
If you give more details about what you're doing, we can show you how to do it simply.
Lilya
2017-12-15
@Guillaume: hmm, I kind of thought I might need datevec components to group but yeah, I agree, using proper datetime format is a better approach.
...I decided to 'trim' the data ...
@Lina: Don't do that. You don't have to lose any data. Simply import your data using readtable
data = readtable(filename);
convert it to timetable,
TT = table2timetable(data,'rowtimes',here goes your datetime column)
then use retime,
TT_weekly = retime(TT,'weekly','mean')
Lilya
2017-12-15
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 MATLAB 的更多信息
Translated by 
