How to find average monthly wind velocity values for given years?
조회 수: 12 (최근 30일)
이전 댓글 표시
I am new to MatLab and trying to create an average monthly wind velocity array for three separate years (2017-19), which I can then plot against each other and finally calculate the accumulated monthly mean from 2017-19.
This is the table formatting
How would I separate each year and determine the monthly mean wind velocities, which I can then insert into a line chart such as this (below) showing each year?
댓글 수: 3
채택된 답변
Adam Danz
2021년 2월 26일
Use groupsummary to compute the means for 12 months across all days/years.
Demo:
T = table((1:10)', randi(12,10,1), 2017.*ones(10,1), randi(20,10,1)+200, rand(10,1)*20, ...
'VariableNames', {'Day','Month','Year','WindDirection','WindSpeed'})
groupsummary(T,'Month','mean',{'WindDirection','WindSpeed'})
댓글 수: 2
Naseef Muhammed
2022년 9월 9일
Taking arithmatic means of wind direction is wrong. For example, based on 'groupsummary' average of 358 and 6 degree will results in 182 which is abselutely wrong.
Adam Danz
2022년 9월 16일
@Naseef Muhammed, true, for circular data you'd want to compute the circular average.
Note that the demo data in my answer are all within the interval [200:220] so the regular old mean would return the same as the circular mean in this case.
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Whos에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!