Match columns containing numbers in two cell arrays.Join the cell arrays.
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Guillaume
2014-9-9
编辑:Guillaume
2014-9-9
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 个评论
Guillaume
2014-9-10
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).
更多回答(1 个)
Andrei Bobrov
2014-9-9
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];
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!