How do I calculate the mean value for the days in a big data set?

2 次查看（过去 30 天）
Johan Wilson
Johan Wilson 2017-5-4
编辑： Johan Wilson 2017-5-4
Hi I have a big data set 46933x12 and the data is collected every 5 minuets and the dates looks like
2014-01-01 00:00:00
2014-01-01 00:05:00
2014-01-01 00:10:00
... I want to have mean values for each of the 11 columes. How do i do this?
  6 个评论
显示 4更早的评论

请先登录，再进行评论。

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

采纳的回答

KL
KL 2017-5-4
Here is a sample code with 3 variables and 5 days with uniform 5 minute timestep
a = rand(288*5,3);
t = (1:288:288*6)';
amean = zeros(5,3);
for i=1:length(t)-1
amean(i,:) = mean(a(t(i):t(i+1)-1,:));
end

更多回答（2 个）

Andrei Bobrov
Andrei Bobrov 2017-5-4
编辑：Andrei Bobrov 2017-5-4
T = table2timetable(readtable('Test.Dataset.xls','ReadVariableNames',false));
out = retime(T,'daily','mean');
or for MATLAB <= R2016a
T = readtable('Test.Dataset.xls','ReadVariableNames',false);
[a,b,c] = datevec(T.Var1);
[dv,~,t] = unique([a,b,c],'rows');
[x,y] = ndgrid(t,1:size(T,2)-1);
out1 = [dv,accumarray([x(:),y(:)],reshape(T{:,2:end},[],1),[],@mean)];
  1 个评论
Johan Wilson
Johan Wilson 2017-5-4
编辑：Johan Wilson 2017-5-4
I downloaded mathlab 2017 had 2015 before. It looks like it works for the small sample but it dont work for the full set. This is a slightly bigger one.

请先登录，再进行评论。

Baptiste Ranguetat
meanData = zeros(1,11);
for i=1:11
meanData(i) = mean(data(:,i));
end

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by