Info

This question is closed. Reopen it to edit or answer.

How to compare two matrices of different dimentions and get the result in new column

1 view (last 30 days)
Hi everyone,
i wanne compare data in two column and get the result in a new column if my condition is true.
A = [2000;1950 ; 1980;2500 ; 2000 ; 5000 ; 2300 ;2000'];
B = [2;2;1;3;1;5;3;3 ; 2;3];
wanne go through all value in B and write in new column when they meet/ equal to 2000.
many thanks
/SA
  2 Comments
Stephen23
Stephen23 on 17 Jun 2019
ShayanA's "Answer" moved here:
Hi there,
actually wane go through two column (A & B )and find out all the data in B which is equal to 2000 in A.
then wanne show the result in new column. if not then NA or Zero in the new column.
hope i could specify better now :)
Thanks
SA

Answers (3)

Fabio Freschi
Fabio Freschi on 17 Jun 2019
Try this
% find logical indices in A with 2000
idxLog = A == 2000;
% create the new vector with B values in idxLog and zeros in ~idxLog
Bnew = zeros(size(B));
Bnew(idxLog) = B(idxLog);
However it is still puzzling me why A and B have different dimensions

Andrei Bobrov
Andrei Bobrov on 17 Jun 2019
Bnew = B.*(A == 2000);

ShayanA
ShayanA on 18 Jun 2019
I appreciated Andrei & Fabio
Shayan

Community Treasure Hunt

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

Start Hunting!