how i do loop over column?

1 次查看(过去 30 天)
Lilya
Lilya 2017-12-15
评论: Lilya 2017-12-15
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.
  2 个评论
KSSV
KSSV 2017-12-15
Read about reshape
Lilya
Lilya 2017-12-15
KSSV, thank you for your response. but I cant get the result

请先登录,再进行评论。

采纳的回答

KL
KL 2017-12-15
编辑:KL 2017-12-15
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.
Take a look at the examples on this page: https://www.mathworks.com/help/matlab/timetables.html
  5 个评论
KL
KL 2017-12-15
编辑:KL 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
Lilya 2017-12-15
Fantastic * _ * ... thanks so much!

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile 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