how to get the mean for specific rows number of one columns

1 vue (au cours des 30 derniers jours)
Hazem Mahmoud
Hazem Mahmoud le 21 Fév 2021
Commenté : Hazem Mahmoud le 22 Fév 2021
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

Réponse acceptée

Paul Hoffrichter
Paul Hoffrichter le 22 Fév 2021
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 commentaires
Paul Hoffrichter
Paul Hoffrichter le 22 Fév 2021
Is this what you want?
plot(Tmean.Month, Tmean.mean_Rainfall, '-bo')
Hazem Mahmoud
Hazem Mahmoud le 22 Fév 2021
Yes, Sir. It worked :)
Thank you so much

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Creating and Concatenating Matrices dans Help Center et File Exchange

Produits


Version

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by