Find elements from a matrix and sum variables from other matrix

2 次查看（过去 30 天）
nlm
nlm 2019-2-9
评论： nlm 2019-2-10
Hi,
I have a matrix of lat long (406, 964) say A, and B. I also have a huge matrix of length 36000 and 3 variables (lat, long, intensity), say C. The lat lon in C have repeated values. I need to find only the elements of A and B that match in C, but also sum the intensity values of all those matching coordinates.
Thank you. Look forward to you help.

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

采纳的回答

Matt J
Matt J 2019-2-9
T=array2table(C);
Gs = groupsummary(T,{'C1','C2'},@sum);
Gs = table2array(Gs(:,[1,2,4]));
bool=ismember(Gs(:,1),A) & ismember(Gs(:,2),B);
result=Gs(bool,:),
  2 个评论
nlm
nlm 2019-2-9
array2table and group summary did the trick I was looking for. Thanks alot.
nlm
nlm 2019-2-10
I have a matrix of lat lon count, where for same lat lon, the count variable range between 1 to 4.
I need to have something like this,
LAT LON cnt = 1 cnt=2 cnt=3 cnt =4
12.4 91.4 1 0 3 0
31.4 45.6 2 4 0 9
45.9 91.5 10 0 9 20
I tried table, I could not figure out.

请先登录，再进行评论。

更多回答（1 个）

Matt J
Matt J 2019-2-9
Na=numel(A);
Nb=numel(B);
[~,Ia]=ismember(C(:,1),A(:));
[~,Ib]=ismember(C(:,2),B(:));
result = accumarray([Ia,Ib],C(:,3),[Na,Nb]);
  1 个评论
nlm
nlm 2019-2-9
This issued an error,
"Error using accumarray
Requested 391384x391384 (1141.3GB) array exceeds maximum array size preference."

请先登录，再进行评论。

类别

在 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