清空筛选条件
清空筛选条件

selecting multiple strinfs of variables

2 次查看（过去 30 天）
ektor
ektor 2012-5-14
Dear all,
I have produced the following output
county interst rate
England b1
England b1
England b1
England b1
England b2
England b2
England b2
England b3
England b3
England b4
England b4
The above table says that for England we have different types of interest rate. I would like to select the values of interest rates that correspond to both bi and b2.
If I use the command
strcmp(mdata1(:,2),'b1')
i select only b1. But I want to select both b1 and b2 Any suggestions?
thanks in advance,
stef

请先登录，再回答此问题。

采纳的回答

Titus Edelhofer
Titus Edelhofer 2012-5-14
Hi Stef,
I guess you are looking for ismember:
ismember(mdata(:,2), {'b1' 'b2'})
Titus
  1 个评论
ektor
ektor 2012-5-14
Hi Titus,
It worked!. thank you so much. I would like to ask you something relevant to the previous question. Apart from the above columsn I have also another column that takes numerical values but has the following structure
[10]
[10]
[10]
[10]
[10]
[10]
[10]
[10]
[10]
[10]
[10]
[8]
[8]
[8]
[8]
[ 7]
[ 7]
[ 7]
[ 0]
[ 0]
Again, I want to select b1 and b2 from the column
"interest rate ínterest" AND the number 7 and 0 from the above column so as to find the corresponding values of interest rates.
I was thinking something like
ismember(mdata(:,2), {'b1' 'b2'}) & something else" "
but i do not know what this "something else" is. your help is greatly appreciated

请先登录，再进行评论。

更多回答（1 个）

ektor
ektor 2012-5-14
Hi Titus,
It worked!. thank you so much. I would like to ask you something relevant to the previous question. Apart from the above columsn I have also another column that takes numerical values but has the following structure
[10]
[10]
[10]
[10]
[10]
[10]
[10]
[10]
[10]
[10]
[10]
[8]
[8]
[8]
[8]
[ 7]
[ 7]
[ 7]
[ 0]
[ 0]
Again, I want to select b1 and b2 from the column "interest rate ínterest" AND the number 7 and 0 from the above column so as to find the corresponding values of interest rates.
I was thinking something like
ismember(mdata(:,2), {'b1' 'b2'}) & something else" " but i do not know what this "something else" is. your help is greatly appreciated
Comment on this Answer
  2 个评论
Titus Edelhofer
Titus Edelhofer 2012-5-14
The values you have seem to be a cell array. Convert it to a double array:
doubleArray = cell2mat(cellArray);
Then you can use it lile
ismember(mdadata(:,2), {'b1' 'b2'}) & (doubleArray==0 | doubleArray==7)
ektor
ektor 2012-5-14
Thank you so much for one more time. you were correct!

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by