Match columns containing numbers in two cell arrays.Join the cell arrays.
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
avantika
am 9 Sep. 2014
Kommentiert: avantika
am 10 Sep. 2014
I have a cell array named data (7886x15 cell). The 15th column of this cell array contains the information of participant number ( 1, 5 , 7, 10 ...and so on). There is another cell array called participant_detail that contains (696x29 cell) in which the 2nd column contains the participant number.
I want to write a command line that matches the participant number (i.e. 15th column of data cell array with the 2nd column of participant_detail cell array). Then picks up the corresponding row of participant_detail cell array and adds it from 16th column onward in the data cell array.
Can anyone help me out.Thanks in advance.
0 Kommentare
Akzeptierte Antwort
Guillaume
am 9 Sep. 2014
Bearbeitet: Guillaume
am 9 Sep. 2014
Assuming that a participant can always be found:
[~, pdrow] = ismember([data{:,15}], [participant_detail{:, 2}]);
data(:,16:44) = participant_detail(pdrow,:);
If not:
[found, pdrow] = ismember([data{:,15}], [participant_detail{:, 2}]);
data(found,16:44) = participant_detail(nonzeros(pdrow),:);
6 Kommentare
Guillaume
am 10 Sep. 2014
Well, as I said, pdetail is not 29 columns but only 9.
Furthermore, the id column in pdetail is 1, not 2 as you've stated.
You also never mentioned anything about row headers. That completely messes up things.
For this data, the proper code would be:
[~, pdrow] = ismember([data{2:end,15}], [pdetail{2:end, 1}]);
data(2:end,16:24) = pdetail(pdrow + 1,:); %or replace the 24 by 15+size(pdetail, 2) to be safe
If some Pid are missing in pdetail, then:
[found, pdrow] = ismember([data{2:end,15}], [pdetail{2:end, 1}]);
data([0 found],16:24) = pdetail(nonzeros(pdrow)+1,:);
As you can see, having the headers complicates things a bit, so you may be better off removing them.
Note that if the code is working right, ismember should returns as many numbers as the number of rows in data (header not included).
Weitere Antworten (1)
Andrei Bobrov
am 9 Sep. 2014
A - cell array 7886x15; B - cell array 696x29
[l,ii] = ismember([A{:,15}],[B{:,2}]);
D = cell(size(A,1),size(B,2));
D(l,:) = B(ii(l),:);
out = [A, D];
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!