How to take mean of rows of particular value?
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Keegan Carvalho
el 26 de Abr. de 2020
Comentada: darova
el 27 de Abr. de 2020
I have an excel file with three columns (Year, Month, Temp). I wanted to find the monthly mean of Temp values from 1997 to 2019 i.e. Jan-97, Feb-97 and so on...
Now, the table (file atteached) has many values for Month 1, Month 2, etc. This is because I have extracted values from different grid points and hence is a little messy. It looks like this:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/287768/image.png)
I used the sortrows function to order the table. However, I do not know how to proceed further. My main aim is to sort the data with respect to Month (Jan-1997, Feb-1997 ... Dec-2019) and then calculate the monthly mean of Temp values from Jan-1997 to Dec-2019. Looking forward to your assistance
2 comentarios
darova
el 26 de Abr. de 2020
Everything looks correct. Sortred by rows. What is wrong?
Use mean to calculate mean value
Respuesta aceptada
darova
el 26 de Abr. de 2020
Sort your data and use for loop
schematic code (not tested)
s = 0; % sum of group data
k = 1; % index of group start
for i = 1:n-1
s = s + a(i);
if a(i) ~= a(i+1)
a1(k:i) = s/(i-k+1); % write mean inside a1
s = 0; % zeros sum
k = i; % new group start
end
end
10 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!