work with matrix of words and number
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Madan Ghimire
il 15 Ago 2019
Commentato: Madan Ghimire
il 16 Ago 2019
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
0 Commenti
Risposta accettata
Andrei Bobrov
il 16 Ago 2019
T = readtable('txtfile.txt')
T_out = varfun(@mean,T,'GroupingVariables','Var1');
Più risposte (1)
Walter Roberson
il 15 Ago 2019
[unique_names, ~, idx] = unique(YourCell(:,1));
mean_per_word = accumarray(idx, cell2mat(YourCell(:,2)), [], @mean);
output = [unique_names, num2cell(mean_per_word)];
0 Commenti
Vedere anche
Categorie
Scopri di più su Data Types in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!