two for Nested Loops

Your question is a little unclear. Do you want to sum all values of the third row when the second row equals 0, equals 1, etc, so you end up with 24 summed values? That is easy:

A = xlsread('average24');
S = accumarray(A(:,2)+1, A(:,3), [24,1], @mean)
% S(k) is the average of all values of A(:,3) when A(:,2) equals (k-1)

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

Jos (10584) 2017-12-14

you want the average, answer corrected! :)

请先登录，再进行评论。

Answer 2

Jan 2017-12-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/372941-two-for-nested-loops#answer_296238

编辑：Jan 2017-12-14

在 MATLAB Online 中打开

Maybe

A = xlsread('average24');
% Average over blocks of 24 values:
S1 = mean(reshape(A(:, 3), 24, []), 1);
% Or average over all values belonging to 0, 1, 2, ...:
S2 = mean(reshape(A(:, 3), 24, []), 2);

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

请先登录，再进行评论。

Answer 3

KL 2017-12-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/372941-two-for-nested-loops#answer_296242

编辑：KL 2017-12-15

在 MATLAB Online 中打开

An example with timetable,

EDITED

%import data
data = readtable('actual data.txt');
%create a proper datetime column
data.Timestamp = datetime(cell2mat(data{:,[1 2]}),'InputFormat','yyyy.MM.ddHH:mm');
%keep only datetime and measurements
data = data(:, [end 3]);
%create timetable
TT = table2timetable(data(:,2),'rowtimes',data.Timestamp);
%calculate daily mean
TT_mean = retime(TT,'daily','mean');

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

请先登录，再进行评论。

Answer 4

ahmad Saad 2017-12-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/372941-two-for-nested-loops#answer_296250

I'm very grateful for all. i'll check the answers and feek back

the answers are really helpfull

thanks again

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

请先登录，再进行评论。

Answer 5

ahmad Saad 2017-12-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/372941-two-for-nested-loops#answer_296362

actual data.txt

This the actual data

from 1/10/2017 to 30/11/2017 the output should have 61 values

4 个评论
显示 2更早的评论隐藏 2更早的评论

KL 2017-12-15

编辑：KL 2017-12-15

在 MATLAB Online 中打开

The answer I gave you works on your text file. I tested it before posting it here!

This is the output

 TT_mean =
  61×1 timetable
       Time        Var3 
    __________    ______
    2017-10-01    9383.2
    2017-10-02    9388.9
    2017-10-03    9420.8
    2017-10-04    9449.3
    2017-10-05      9463
    2017-10-06    9456.5
    2017-10-07    9406.2
    2017-10-08    9364.3
    2017-10-09    9386.4
    2017-10-10    9440.3
    ...