MATLAB: Determine index of a value (monthly) from excel table

index monthly mean for time series

Hi.. how i can determine index monthly mean for time series each years i have ponit every houer so in one day i have 24 points and each month i have difrrent number of points , like Jan 24×31=744 , Feb 24×28=672… I find some months incomplete

Best Answer

If you are using R2016b or later, use a timetable, and call retime to compute a monthly mean. Even prior to 16b, you should use a table with a datetime variable in it, and use varfun to compute the mean with month as the grouping variable.
Related Question