Count the occurence certain elements based on condition in next column

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

0 个投票

Hello.
I have a matrix consists of A = [ 1 3 2 2 4 1 2 3 4 1 3] and B = [0 0 -3 0 2 1 4 0 0 -2 0]
How can I determine the occurence of element in A when corresponding value in B is not 0:
C = [
1 2
2 2
3 0
4 1]
Please help me..
Really appreciate it!!

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

更多回答（1 个）

Ameer Hamza
Ameer Hamza 2020-11-3
编辑：Ameer Hamza 2020-11-3

0 个投票

Try this
A = [1 3 2 2 4 1 2 3 4 1 3];
B = [0 0 -3 0 2 1 4 0 0 -2 0];
C = [1:max(A); histcounts(A(B~=0), 'BinMethod', 'integers')].'

9 个评论
显示 7更早的评论 隐藏 7更早的评论

Daniar Fahmi
Daniar Fahmi 2020-11-4
Woww.. Thank you very much. Exactly what I need!!
Daniar Fahmi
Daniar Fahmi 2020-11-4
编辑：Daniar Fahmi 2020-11-4
Hi..
Is there any limitation for histcounts function? because when I used it in larger data (near 2 x 60M) and then it was found that unique element (vector A) was 360 data, the result of histcounts was only 300 data
Ameer Hamza
Ameer Hamza 2020-11-4
Following solution will be more robust
A = dataPD(1,:);
B = dataPD(2,:);
C = [1:max(A); histcounts(A(B~=0), 0.5:1:max(A)+0.5)].'
Bruno Luong
Bruno Luong 2020-11-4
编辑：Bruno Luong 2020-11-4
Attention A of your data contains 82335 0s and they are discarded from counting

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by