How to get monthly average
조회 수: 1 (최근 30일)
이전 댓글 표시
I have data (47 * 1)for 26 months starting in 2015 ending in 2107 as the Xlsx file
Some months it has 3 values and some are 2 or1
I want to get average values for each month as new-data(26*1).
Any suggestion, to help me?
댓글 수: 0
답변 (1개)
dpb
2018년 10월 15일
t=readtable('month.xlsx');
t=table2timetable(t);
mn=retime(t.Var1,'monthly',@mean);
I didn't download the file so if there are variable names for Var1 use whatever the variable is.
댓글 수: 2
참고 항목
카테고리
Help Center 및 File Exchange에서 Get Started with MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!