Repeated values (multiple data points at the same location).

4 次查看（过去 30 天）
Kyriakos Kokolakis
Kyriakos Kokolakis 2016-2-21
评论： Star Strider 2016-2-22
Hi all,
I have an array of data and in the first column there are some repeated values (multiple data points at the same location). With those repeated values I'd like to average the associated data in column 2.
Example array: [1 3.1; 2 4.5; 3 5.7; 4 8.2; 4 5.2;]
I'd like to create a new array that looks like this: [1 3.1; 2 4.5; 3 5.7; 4 6.7;]
Thanks for any help.
-K

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

采纳的回答

Star Strider
Star Strider 2016-2-21
The accumarray function will do this if you ask it nicely:
ExArray = [1 3.1; 2 4.5; 3 5.7; 4 8.2; 4 5.2;];
[UExA, ia, ic] = unique(ExArray(:,1));
Out = [ExArray(ia,1) accumarray(ic, ExArray(:,2), [], @mean)]
Out =
1 3.1
2 4.5
3 5.7
4 6.7
  4 个评论
显示 2更早的评论

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by