Match columns containing numbers in two cell arrays.Join the cell arrays.
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Guillaume
le 9 Sep 2014
Modifié(e) : Guillaume
le 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 commentaires
Guillaume
le 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).
Plus de réponses (1)
Andrei Bobrov
le 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];
Voir également
Catégories
En savoir plus sur Matrices and Arrays dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!