error in selecting data
1 次查看(过去 30 天)
显示 更早的评论
i have a data of 2 columns
d= [12] 'A'
[23] 'B'
[18] 'H'
d1=[23 45]
out = [d1, d(ismember(d(:,1),d1(:,1),'rows'),1:end)]
if i do this i get error
Input must be cell arrays of strings
please help
0 个评论
采纳的回答
Sven
2011-11-15
Hi FIR,
The error comes because the ismember() function expects either a matrix of numbers or a cell array of strings. Since d is a cell, you provided a cell array of numbers which is unfortunately invalid. Try converting to numbers like the following:
dMask = ismember(cell2mat(d(:,1)), d1);
Secondly, you were trying to concat d1 (which is a 1x2 matrix) with various rows of a cell (ie, an nx2 cell):
out = [d1, d(dMask,:)]
This won't work on two counts:
1. Cells won't concat with matrices - one of them needs to be converted.
2. d1 is 1x2, which won't concat if your result has more than 1 rows.
------
So, I've updated my answer as below from the comments you made. Firstly, we have your inputs d and d1 as follows:
d = {12 'A'; 23 'B'; 18 'H'; 12 'P'};
d1 = [23 45;18 10];
And what you actually want to do is concat d1 with its corresponding indices into d. Note that this means you're asking which entries in the first column of d1 are members of the first column of d... Note that this is the opposite ordering from your original question, but it seems more logical. Try the following two lines, I think that they answer your question:
[dMask, indices] = ismember(d1(:,1), cell2mat(d(:,1)));
[num2cell(d1(dMask,:)) d(indices,2)];
Does this help?
12 个评论
Sven
2011-11-16
I'm a bit lost on what you want to do here, and it seems quite a different topic to the original question. I suggest hitting "accept" to the original question, and then asking a new question specifically about "how to format rows columns for display". If you can make a short example showing exactly the input you have and the output you want, I'm sure it will get a clear answer.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!