Determine averages for duplicate values
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi,
I have a cell array (11708 x 1) called "merged" where each value is the station name and the channel. I also have the residual for each entry in this cell array also as a cell array (11708 x 1). I want to determine the average residual for each station i.e. find duplicate entries and average associated values.
Example "merged" cell array entry: SUE HHE (i.e. its text) Example "res" cell array entry: 1.4224
If anyone could provide some help for this it would be much appreciated.
Cheers
0 commentaires
Réponse acceptée
KL
le 13 Déc 2017
use a table and then varfun with grouping variable as your station name,
T = cell2table(C,'v',{'stationName','channelName',residual'});
T1 = varfun(@mean,T,'GroupingVariables','stationName');
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Characters and Strings dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!