calculate average only for one group

2 次查看（过去 30 天）
alpedhuez
alpedhuez 2020-7-6
回答： Image Analyst 2020-7-6
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.

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

回答（2 个）

alpedhuez
alpedhuez 2020-7-6
Image Analyst
Image Analyst 2020-7-6
Try the built-in functions grpstats() or splitapply(). Attach code to make your table if you need more help.

类别

在 Help Center 和 File Exchange 中查找有关 Whos 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by