Print output if elements of a list match values in a column

5 Ansichten (letzte 30 Tage)
I have a column/list of values A:
1
2
3
4
5
6
7
8
9
10
And an according list/column of values B:
A
B
C
D
E
F
G
H
I
J
From the column/list of A I am extracting certain values e:
3
6
8
10
Now I have a column C containing values of B in a random order:
A
A
B
F
D
H
C
E
K
C
J
A
And according values in column D:
0.01
0.02
0.12
0.13
0.24
0.09
0.14
0.01
0.04
0.07
0.12
0.19
First step I need to do is match the extracted values e with the values in column A to get the according values from column B to get values f:
C
F
H
J
Second step is to match values in f with values in C and get their according values to g; else it is 0:
0
0
0
0.13
0
0.09
0.14
0
0
0.07
0.12
0
How can I do those steps?
I thought about runnig a loop, but it wont work for me.
Thanks for your help!

Akzeptierte Antwort

Stephen23
Stephen23 am 3 Mai 2021
Bearbeitet: Stephen23 am 3 Mai 2021
A = [1;2;3;4;5;6;7;8;9;10];
B = ["A";"B";"C";"D";"E";"F";"G";"H";"I";"J"];
e = [3;6;8;10];
C = ["A";"A";"B";"F";"D";"H";"C";"E";"K";"C";"J";"A"];
D = [0.01;0.02;0.12;0.13;0.24;0.09;0.14;0.01;0.04;0.07;0.12;0.19];
[X,Y] = ismember(e,A);
f = B(Y(X))
f = 4×1 string array
"C" "F" "H" "J"
Z = ismember(C,f);
g = zeros(size(C));
g(Z) = D(Z)
g = 12×1
0 0 0 0.1300 0 0.0900 0.1400 0 0 0.0700

Weitere Antworten (0)

Kategorien

Mehr zu Simulink Coder finden Sie in Help Center und File Exchange

Produkte


Version

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by