Colon operator for cells

Question

Max Bornemann 2019-4-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/457836-colon-operator-for-cells

评论： Max Bornemann 2019-4-22

Hello,

i have the following table:

Tab1=table('Size',[9 2],'VariableTypes',{'cell','double'},'VariableNames',{'Description','Value'});
Tab1.Description(:)={'Name1','Name2','Name3','Name4','Name5','Name6','Name7','Name8','Name9'};
Tab1.Value(:)=[5,10,17,7,25,75,23,47,54];
Tab1=
Description           Value
_______               _______
'Name1'	        5
'Name2'	        10
'Name3'	        17
'Name4'	        7
'Name5'	        25
'Name6'	        75
'Name7'	        23
'Name8'	        47
'Name9'	        54

I want to access Description from 'Name3' until 'Name8', is there a way to do it with the concrete content ('Name3' and 'Name8') and without using the rows/columns?

So i want the solution of the following calculation, but the calculation itself should be different:

Tab1.Description(3:8,1);
'Name3'
'Name4'
'Name5'
'Name6'
'Name7'
'Name8'

I am searching for a solution similar to:

Tab1.Description({'Name3'}:{'Name8'});

This doesnt work, because of: Undefined operator ':' for input arguments of type 'cell'.

I will greatly appreciate any assistance.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

madhan ravi 2019-4-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/457836-colon-operator-for-cells#answer_371707

在 MATLAB Online 中打开

idx="Name"+(3:8);
Tab1(ismember(Tab1{:,1},idx),:)

4 个评论
显示 2更早的评论隐藏 2更早的评论

madhan ravi 2019-4-22

编辑：madhan ravi 2019-4-22

在 MATLAB Online 中打开

So mention the idx as is and then use ismember() ?

idx = {'Max'
'Name4'
'Name5'
'Name6'
'Name7'
'Linda'};
Tab1(ismember(Tab1{:,1},idx),:)

Max Bornemann 2019-4-22

Sorry about the circumstances. Like this i would have the solution i want (idx) by just writing it down. I just need variable description, the corresponding value is not needed. Imagine there are way more rows with various names between 'Max' and 'Linda' and i dont even no them. I just know that 'Max' and 'Linda' are unique in description. So is there a way to "cut out" from Tab1.description every entry from 'Max' to 'Linda' including both?

请先登录，再进行评论。