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

2 visualizaciones (últimos 30 días)
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

Respuesta aceptada

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

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Data Preprocessing en Help Center y File Exchange.

Productos


Versión

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by