Determine averages for duplicate values

BOB
2017 12 13
1 个回答
回答已采纳
更新时间：2017 12 13
63 次查看（30 天）

0 个投票

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

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

 采纳的回答

KL
KL 2017-12-13

0 个投票

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 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

提问:

BOB
BOB
2017-12-13

回答：

KL
KL
2017-12-13

Community Treasure Hunt

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

Start Hunting!

Translated by