MATLAB Answers

BOB
0

Determine averages for duplicate values

Asked by BOB
on 13 Dec 2017
Latest activity Answered by KL
on 13 Dec 2017
Accepted Answer by KL
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 Comments

Sign in to comment.

1 Answer

Answer by KL
on 13 Dec 2017
 Accepted Answer

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 Comments

Sign in to comment.