calculate average only for one group
조회 수: 1 (최근 30일)
이전 댓글 표시
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
답변 (2개)
Image Analyst
2020년 7월 6일
Try the built-in functions grpstats() or splitapply(). Attach code to make your table if you need more help.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Workspace Variables and MAT-Files에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!