Joining a table using a column of list
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Douglas Chiang
am 28 Aug. 2020
Kommentiert: Douglas Chiang
am 3 Sep. 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 Kommentare
Walter Roberson
am 28 Aug. 2020
Does order matter? Alternately, will VarB always be in increasing order? Will VarC always be in increasing order?
Akzeptierte Antwort
Mohammad Sami
am 28 Aug. 2020
Bearbeitet: Mohammad Sami
am 28 Aug. 2020
Try this
if true
tabA.VarE = cellfun(@(X)tabB.VarD(ismember(tabB.VarC,X)),tabA.VarB,'UniformOutput',false);
end
6 Kommentare
Mohammad Sami
am 29 Aug. 2020
Bearbeitet: Mohammad Sami
am 29 Aug. 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);
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Matrices and Arrays finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!