work with matrix of words and number

1 次查看（过去 30 天）
Madan Ghimire
Madan Ghimire 2019-8-15
评论： Madan Ghimire 2019-8-16
Hey guys,
I work with matrix that have words on one column and their corresponding value on the other column as such
'Apple' 13.6000000000000
'Apple' 7.23200000000000
'Apple' 6.73600000000000
'Ball' 1.34900000000000
'Cat' 1.71600000000000
'Dog' 2.66100000000000
'Cat' 0.771000000000000
and the order of these words is random. I need to calculate the mean for individual words. I appretiate any help.
thanks

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2019-8-16
T = readtable('txtfile.txt')
T_out = varfun(@mean,T,'GroupingVariables','Var1');

更多回答（1 个）

Walter Roberson
Walter Roberson 2019-8-15
[unique_names, ~, idx] = unique(YourCell(:,1));
mean_per_word = accumarray(idx, cell2mat(YourCell(:,2)), [], @mean);
output = [unique_names, num2cell(mean_per_word)];

类别

在 Help Center 和 File Exchange 中查找有关 NaNs 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by