Joining a table using a column of list
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Douglas Chiang
il 28 Ago 2020
Commentato: Douglas Chiang
il 3 Set 2020
Hi all, I have two tables as shown:
Table A (size mxn):
VarA VarB .....
------ -------
3 [1, 5, 7]
167 [2, 6, 9, 11]
......
Table B (size axb):
VarC VarD .....
------ -------
1 "X"
2 "B"
5 "E"
6 "F"
7 "G"
9 "I"
11 "R"
...
I would like to make use of Table B to join a new column to Table A like below:
New Table A:
VarA VarB VarE .....
------ ------- -------
3 [1, 5, 7] ["X", "E", "G"]
167 [2, 6, 9, 11] ["B", "F", "I", "R"]
......
Any help is much appreciated.
3 Commenti
Walter Roberson
il 28 Ago 2020
Does order matter? Alternately, will VarB always be in increasing order? Will VarC always be in increasing order?
Risposta accettata
Mohammad Sami
il 28 Ago 2020
Modificato: Mohammad Sami
il 28 Ago 2020
Try this
if true
tabA.VarE = cellfun(@(X)tabB.VarD(ismember(tabB.VarC,X)),tabA.VarB,'UniformOutput',false);
end
6 Commenti
Mohammad Sami
il 29 Ago 2020
Modificato: Mohammad Sami
il 29 Ago 2020
You will need to convert the categorical array to cellstr, then convert it double.
tabA.VarB = cellstr(tabA.VarB);
tabA.VarB = regexprep(tabA.VarB,'[\[\]]','');
tabA.VarB = cellfun(@(x)str2double(strsplit(x,',')),tabA.VarB,'UniformOutput',false);
tabA.VarE = cellfun(@(X)tabB.VarD(ismember(tabB.VarC,X)),tabA.VarB,'UniformOutput',false);
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Matrices and Arrays 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!