Most common pair in a matrix.

2020 11 4
1 个回答
回答已采纳
更新时间：2020 11 4
4 次查看（30 天）

0 个投票

I have a list of lat/lon coordinates and I would like to find the most common locations. Is there a built in function for this?
Thank you.

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

 采纳的回答

Star Strider
Star Strider 2020-11-4

0 个投票

Try this:
M = randi(5, 25, 2); % Create ‘LatLon’ Data
[Mu,~,idx] = unique(M, 'rows'); % Unique Rows
Tally = accumarray(idx, (1:numel(idx)).', [], @(x) {M(x,:)}); % Calculate Frequencies, Return Pairs By Group
pairs = cellfun(@(x)size(x,1), Tally); % Recover ‘LatLon’ Pairs
[~,ixs] = sort(pairs, 'descend'); % Sort Them
Result = table(Mu(ixs,:),pairs(ixs), 'VariableNames',{'LatLon','Frequency'}); % Output Table Of Pairs & Frequencies
I did my best to comment-document it. Use your own latitude & longitude coordinates for ‘M’. It may be necessary to use uniquetol with the 'ByRows' option if the coordinates are not exactly the same.

2 个评论
显示 无 隐藏 无

Erick Koenig
Erick Koenig 2020-11-4
Awesome! works perfectly. That's exactly what I was looking to do. Thank you.
Star Strider
Star Strider 2020-11-4
Thank you! As always, my pleasure!

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by