how to get the mean for specific rows number of one columns
2 次查看(过去 30 天)
显示 更早的评论
1 5
2 7
3 9
1 9
2 7
3 9
if column 1 is month how to get the mean of January only which is 5 and 9 then feb which is 7 and 7 mean then march 9 and 9 mean
Thanks in advance
0 个评论
采纳的回答
Paul Hoffrichter
2021-2-22
M = [ ...
1 5
2 7
3 9
1 9
2 7
3 9
];
T = array2table( M, ...
'VariableNames',{'Month','Rainfall'});
disp('Table');
disp(T)
Tmean = varfun(@mean,T,'InputVariables','Rainfall',...
'GroupingVariables','Month');
disp('Mean of Rainfall by Month')
disp(Tmean)
Output
Table
Month Rainfall
_____ ________
1 5
2 7
3 9
1 9
2 7
3 9
Mean of Rainfall by Month
Month GroupCount mean_Rainfall
_____ __________ _____________
1 2 7
2 2 7
3 2 9
5 个评论
Paul Hoffrichter
2021-2-22
Is this what you want?
plot(Tmean.Month, Tmean.mean_Rainfall, '-bo')
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Preprocessing 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!