Averaging and summing parts of a column based on date

Question

Wendy Cameron 2019-1-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/441373-averaging-and-summing-parts-of-a-column-based-on-date

评论： Wendy Cameron 2019-1-30

Matlab question.xlsx

Greetings Matlab community

I have some very large data sets and I am wanting to sum and average parts of a table column based on the date. I have multiple readings of e.g. temperature for a given date and want to both sum and average these for each given date and get a corresponding table with the results.

A VERY cut down version of the data is attached and I want to get a result that has three columns - the date, the average Maxium temperature and the Total max temp for each date.

Much appreciated

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

per isakson 2019-1-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/441373-averaging-and-summing-parts-of-a-column-based-on-date#answer_357975

编辑：per isakson 2019-1-25

在 MATLAB Online 中打开

Ten hours without an answer. Here is the result from my first experiment with timetable. See retime Resample or aggregate data in timetable, and resolve duplicate or irregular times

%%
T = readtable('Matlab question.xlsx');
%%
TT = table2timetable( T, 'rowTimes','Var1' );
%%
dm = retime( TT, 'daily','mean' );
%%
dx = retime( TT, 'daily','max' );
%%
ds = retime( TT, 'daily','sum' );

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

Wendy Cameron 2019-1-30

Thank you. That works. I am now wondering if one can turn a timetable e.g. dm etc, back to a table?

请先登录，再进行评论。

Answer 2

Andrei Bobrov 2019-1-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/441373-averaging-and-summing-parts-of-a-column-based-on-date#answer_357984

T = readtable('Matlab question.xlsx','Ra','A2:B109','ReadV',0);
out = rowfun(@tempfun,T,'G','Var1',...
    'OutputV',...
    {'MeanTemp' 'MaxTemp'});
function varargout = tempfun(x)
    varargout = {mean(x),max(x)};
end