excel averageif function in matlab

Question

Kuang-Yu WANG 2018-6-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/407998-excel-averageif-function-in-matlab

回答： Steven Lord 2018-6-29

image.png

    for cata = 1:281
       mydata = mean(cellfun(@(x) x(cata,2), thecells));
 data2 = cell2mat(num2cell(mydata));
       plot(cata,data2)
    end

mydata is 5000*2 double look like

time    data  
225.42968
453.4097824
254.1819706
164.3800456
411.2133781
266.0093299
399.3169552
     155.2650000
     322.7854587
     366.5487525

i try many methods but cannot create a loop same as averageif function in excel. my prof tell me to put nan for numbers to create same size for each time. But I am wondering another ways of the averageif function in excel.

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2018-6-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/407998-excel-averageif-function-in-matlab#answer_326783

在 MATLAB Online 中打开

I am not certain what structure your original data are.

Try this:

C = {1  225.42968
453.4097824
254.1819706
164.3800456
411.2133781
266.0093299
399.3169552
 155.2650000
 322.7854587
 366.5487525};
M = cell2mat(C);
Out = accumarray(M(:,1), M(:,2), [], @mean);

2 个评论
显示无隐藏无

Kuang-Yu WANG 2018-6-29

thanks very much!!

Star Strider 2018-6-29

As always, my pleasure!

请先登录，再进行评论。

Answer 2

Steven Lord 2018-6-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/407998-excel-averageif-function-in-matlab#answer_326864

在 MATLAB Online 中打开

If you're using release R2018a and your data is stored as a table, use groupsummary.

time = [1; 1; 1; 2; 2; 2; 2; 3; 4; 4];
data = [225.42968;
        453.4097824;
        254.1819706;
        164.3800456;
        411.2133781;
        266.0093299;
        399.3169552;
        155.2650000;
        322.7854587;
        366.5487525];
T = table(time, data)
groupsummary(T, 'time', 'mean')

Or you could use splitapply (since your times are already group numbers; if they weren't a vector of positive integer values you would need to use findgroups first.)

meantime = splitapply(@mean, data, time)