work with matrix of words and number

1 次查看(过去 30 天)
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 CenterFile Exchange 中查找有关 Data Types 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by