find duplicate values using accumarray() function:

2018 4 19
1 个回答
回答已采纳
更新时间：2018 4 23
2 次查看（30 天）

0 个投票

I have data that contains longitude,latitude,access point address and signal level. I would like to find duplicate longitude,latitude,access point address, then average the signal level over them, and then replacing the original rows with the new single row. How to do this?

For example (made up data):

Starting data:

if true
33.121,-70.630,aa:91:52:9c:72:21,-80
33.122,-70.631,bb:91:52:9c:72:21,-75
33.123,-70.632,cc:91:52:9c:72:21,-84
33.124,-70.633,dd:91:52:9c:72:21,-57
33.121,-70.630,aa:91:52:9c:72:21,-84
33.122,-70.631,bb:91:52:9c:72:21,-73
end

Would become

if true
33.121,-70.630,aa:91:52:9c:72:21,-82
33.122,-70.631,bb:91:52:9c:72:21,-74
33.123,-70.632,cc:91:52:9c:72:21,-84
33.124,-70.633,dd:91:52:9c:72:21,-57
end

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

the cyclist
the cyclist 2018-4-19
How are your data currently stored (e.g. what data type)? Can you post the data, or a small sample that has duplicates?

请先登录，再进行评论。

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

 采纳的回答

Razvan Carbunescu
Razvan Carbunescu 2018-4-19

1 个投票

Using accumarray specifically you could do this by combining with findgroups :

[idx,unique_long,unique_lat,unique_acc] = findgroups(long,lat,acc);
[unique_signal] = accumarray(signal,idx,[],@mean);

In R2018a could also use groupsummary but the data should be in a table:

T = table(long,lat,acc,signal);
GT = groupsummary(T,{'long','lat','acc'},'mean','signal')

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by