MATLAB Answers

calculate average only for one group

20 views (last 30 days)
alpedhuez
alpedhuez on 6 Jul 2020 at 20:43
Answered: Image Analyst on 6 Jul 2020 at 21:11
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.

  0 Comments

Sign in to comment.

Answers (2)


Image Analyst
Image Analyst on 6 Jul 2020 at 21:11
Try the built-in functions grpstats() or splitapply(). Attach code to make your table if you need more help.

  0 Comments

Sign in to comment.

Tags


Translated by