Mean, Max and Min of Structured Cell array

3 次查看（过去 30 天）

Ganesh Naik 2021-4-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/796262-mean-max-and-min-of-structured-cell-array

评论： Ganesh Naik 2021-4-10

Hi all, I have a structured cell array where I need to compute the mean of each cell from column 4. Column 3 contains the name of the data (repeated for number of days 31, 29 etc.). At the end I would like to display the results as name (3rd column one value) , Average, Min and Max of each cell of 4th column data. Any help (sample example) in this regard is highly appreciated. For your reference I have attached the picture.

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

请先登录，再进行评论。

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

采纳的回答

Matt J 2021-4-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/796262-mean-max-and-min-of-structured-cell-array#answer_670257

编辑：Matt J 2021-4-8

在 MATLAB Online 中打开

You should first convert everything to table form.

Column3={{'dog';'dog';'dog'},{'cat';'cat'}}; %Original data
Column4={[1;2;3], [4;5]};
Column3=string( vertcat(Column3{:}) );
Column4=vertcat( Column4{:} );
T=table(Column3,Column4,'VariableNames',{'Names','Data'})
T = 5×2 table
    Names    Data
    _____    ____

    "dog"     1  
    "dog"     2  
    "dog"     3  
    "cat"     4  
    "cat"     5  

From that point on, it all becomes much easier:

 Means = varfun(@mean,T,'GroupingVariables','Names')
Means = 2×3 table
    Names    GroupCount    mean_Data
    _____    __________    _________

    "cat"        2            4.5   
    "dog"        3              2   
 Maxs= varfun(@max,T,'GroupingVariables','Names')
Maxs = 2×3 table
    Names    GroupCount    max_Data
    _____    __________    ________

    "cat"        2            5    
    "dog"        3            3    