conditional selection on table

Question

abdul rehman 2020-7-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/565454-conditional-selection-on-table

评论： abdul rehman 2020-7-16

I want the conditional selecton of a row in a table

where name is ali
where name is ali and age is between 25 to 30
where name is ahmed, I want to multply his age with 2

kindly please help

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

请先登录，再进行评论。

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

Answer 1

KSSV 2020-7-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/565454-conditional-selection-on-table#answer_466142

编辑：KSSV 2020-7-15

在 MATLAB Online 中打开

You can access the columns of the table using T.columnname or T.(1), T.(2) etc...

To get the index where name 'Ali' lies, you can use

idx = strcmp(T.name,'Ali') ; % assuming name column to carry names 
idx = strcmp(T.(1),'Ali') ; % assuming first column to be names 

To get the ages indices.

id = T(idx).age>= 25 & T(idx).age <= 30 ; % assuming age is the column whihc has ages 

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

abdul rehman 2020-7-16

Thank, but its not doing the job. Its 2 line you suggested only returning the array of 0s and 1s. I need the whole row of the record where name ali is present. The last code you suggested is producing error

"Subscripting into a table using one subscript (as in t(i)) or three or more subscripts (as in t(i,j,k)) is not supported. Always specify a row subscript and a variable subscript, as in t(rows,vars)."

kindly if you can guide

请先登录，再进行评论。