Print output if elements of a list match values in a column
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Lukas Netzer
il 3 Mag 2021
Commentato: Lukas Netzer
il 6 Mag 2021
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!
0 Commenti
Risposta accettata
Stephen23
il 3 Mag 2021
Modificato: Stephen23
il 3 Mag 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))
Z = ismember(C,f);
g = zeros(size(C));
g(Z) = D(Z)
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Simulink Coder in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!