calculate average only for one group

I have a table T

YYYY Name Location Income
-----------------
2020 A E 300K
2020 B W 250K
2020 C E 400K
2020 D W 300K

Then I want to take an average of income only for people at West Coast.

unstack{T,'income','location','Grouping Variables','YYYY','AggregationFunction', @mean)

will provide average income for both NY and SF. But I just want to calcuate mean for NY.

Answer 1

[alpedhuez]

https://www.mathworks.com/matlabcentral/answers/366254-how-do-i-extract-certain-data-from-a-table

Answer 2

[Image Analyst]

Try the built-in functions grpstats() or splitapply(). Attach code to make your table if you need more help.