How to take mean of rows of particular value?
2 views (last 30 days)
Show older comments
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:
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 Comments
darova
on 26 Apr 2020
Everything looks correct. Sortred by rows. What is wrong?
Use mean to calculate mean value
Accepted Answer
darova
on 26 Apr 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 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!