Get data from table with two conditions

2019 3 30
1 个回答
回答已采纳
更新时间：2019 3 30
4 次查看（30 天）

0 个投票

See attached picture for a small part of the table. I'm trying to get the column "ahe" as a separate vector, but only include every row that has year 2012, and bachelor 0.
To create the vector and only include every row that has year 2012, I used this line, where T is the table;
T{T.year==1992,'ahe'}
I tried using this to include the bachelor requirement;
T{T.year==1992 && T.bachelor==0, 'ahe'}
But I couldn't get it to work. Any help would be greatly appreciated.

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

 采纳的回答

madhan ravi
madhan ravi 2019-3-30

1 个投票

T{(T.year==1992) & (T.bachelor==0), 'age'}
% ^ ^
% or
T{(T{:,'year'}==1992) & (T{:,'bachelor'}==0), 'age'}

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

产品

版本

R2018b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by