find & replace data in array

조회 수: 9 (최근 30일)
Pierre
Pierre 2013년 9월 17일
Hi, I have two arrays.
A=[7 14 21 28 35 42 49 56 63 70 77 84 91]
B=[22 55]
I wanna find the number in A which is close to the number in B and to replace the number in A by the number in B. Finally, A will be
A=[7 14 22 28 35 42 49 55 63 70 77 84 91].
Is there any better and faster algorithm to solve this issue? Thanks

채택된 답변

Roger Stafford
Roger Stafford 2013년 9월 17일
[~,p] = min(abs(bsxfun(@minus,A,B')),[],2);
A(p) = B;
There is an inherent ambiguity possible in this problem. An element in A that happens to be the closest one to both of two different elements of B could legitimately be replaced by either B element. In the above algorithm it is always the later one in B that does the replacing in such cases.

추가 답변 (2개)

Azzi Abdelmalek
Azzi Abdelmalek 2013년 9월 17일
A=[7 14 21 28 35 42 49 56 63 70 77 84 91]
B=[22 55]
for k=1:numel(B)
[ii,ii]=min(abs(A-B(k)));
A(ii)=B(k);
end

Andrei Bobrov
Andrei Bobrov 2013년 9월 17일
편집: Andrei Bobrov 2013년 9월 17일
A=[7 14 21 28 23 35 21 42 49 56 63 70 54 77 84 91]
B = [22 55]
M = abs(bsxfun(@minus,A,B'));
t = bsxfun(@eq,M,min(M,[],2));
add1 = bsxfun(@times,t,B');
A(any(t)) = add1(t)

카테고리

Help CenterFile Exchange에서 Characters and Strings에 대해 자세히 알아보기

제품

Community Treasure Hunt

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

Start Hunting!

Translated by