Remove array values with multiple occurances from "parent" array

3 Ansichten (letzte 30 Tage)
How do you remove values in an array from a "master database" array? For example:
a = [1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4]
b = [1, 1, 2, 4, 4, 4]
I would like to remove each occurance of each value in 'b' from 'a' to get:
c = 1, 2, 2, 3, 3, 3
setdiff(a, b) doesn't work because it removes all instances from 'a' including the repeating values (it even says no repetitions in the documentation):
c = 3
[~, col] = ismember(b, a)
a(col) = []
doesn't work because it only removes one instance of the numbers (the first index where it occured):
c = 1, 1, 2, 2, 3, 3, 3, 4, 4
Thanks for the help.

Akzeptierte Antwort

David Hill
David Hill am 9 Jul. 2020
Bearbeitet: David Hill am 9 Jul. 2020
a = [1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4];
b = [1, 1, 2, 4, 4, 4];
c = a;
for i=b
c(find(c==i,1))=[];
end
  1 Kommentar
Joe I
Joe I am 9 Jul. 2020
Bearbeitet: Joe I am 9 Jul. 2020
Awesome, thanks! Works great, scales up to my datasets with tens of thousands of values in each. Seems so obvious now after seeing it. Just be sure that each variable is a row vector.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

Bruno Luong
Bruno Luong am 10 Jul. 2020
Bearbeitet: Bruno Luong am 10 Jul. 2020
Test samples
a = [1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4]
b = [1, 1, 2, 4, 4, 4]
Code
u = unique([a,b]);
n = length(u);
[~, ia] = ismember(a,u); na = accumarray(ia(:),1,[n 1]);
[~, ib] = ismember(b,u); nb = accumarray(ib(:),1,[n 1]);
c = repelem(u,max(na-nb,0))
Result
c =
1 2 2 3 3 3

Kategorien

Mehr zu Resizing and Reshaping Matrices finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by