Managing large files - irregular data points

Question

Dirk 2013-7-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/83492-managing-large-files-irregular-data-points

Hi Folks,

I have a data set where the data points are measured at irregular intervals, sometimes 10 measurements per minute, other times more/less. I want to average the values within each minute so I end up with one value per minute. Each data point has a datevec value, e.g. [ 2013 7 25 10 41] which corresponds to 10:41 am on the 25th July. How can I tell Matlab to average all the data points within each minute?

Thanks

3 个评论
显示 1更早的评论隐藏 1更早的评论

Cedric 2013-7-30

Also, do you have minutes with no data point?

Dirk 2013-7-30

The data is currently in two separate arrays taken from the same excel spreadsheet, one with the time and the other with the data. Every time point has a corresponding data point. There is a data point for every minute. Thanks

请先登录，再进行评论。

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

Answer 1

the cyclist 2013-7-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/83492-managing-large-files-irregular-data-points#answer_93065

编辑：the cyclist 2013-7-30

在 MATLAB Online 中打开

Here is how you can do it, if your time data and your measurement data are in two separate arrays:

t = [ 2013 7 25 10 41;
      2013 7 25 10 41;
      2013 7 25 10 41;
      2013 7 25 10 42;
      2013 7 25 10 42;
      2013 7 25 10 43]
m = [1;2;3;4;5;6];
[unique_t,i,j] = unique(t,'rows')
mean_m = accumarray(j,m,[],@mean)