Finding rows with specific values

I have a martrix with year, month, and two variables. With 7 years worth of data.

year month air temp humidity

2007 10 254.2 446.3

I am trying to subset certain months, 10,11,12,1,2,3. I want the data included in the entire row.

Any idea on how i could do this?

Cheers.

Answer 1

[Adam Danz]

Use ismember.

idx = ismember(T.month, [10,11,12,1,2,3]);

T(idx,:)

[Tom Sagar]

T.month being my matrix name?

[Tom Sagar]

Monthly_airtemp = data name



idx = ismember(monthly_airtemp, [10,11,12,1,2,3]); 
monthly_airtemp(idx,:)

[Adam Danz]

I assumed your example below was a table

year month air temp humidity

2007 10 254.2 446.3

If monthly_airtemp is a vector of integers representing months, then your code above should work.