Get data from table with two conditions

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.

Answer 1

[madhan ravi]

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