How to convert daily data to monthly?

21 次查看（过去 30 天）
Mohammad
Mohammad 2012-12-5
回答： ABHILASH SINGH 2020-3-13
I have huge number of precipitation daily data in a column (say for 60 years) for 400 meteorological stations. Now I need to convert it to monthly. How can I do that? thanks.
  2 个评论
per isakson
per isakson 2012-12-5
Months have 28, 29, 30 or 31 days, which makes it a bit tricky.
Do you have a table with
date, value
rather than just a column?
Does the length of the months matter?
Mohammad
Mohammad 2012-12-5
my data format is Year Month Day data
that is in 4 column. Length of month is always 30. Does it help for providing your answer? thanks.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（5 个）

Andrei Bobrov
Andrei Bobrov 2012-12-5
编辑：Andrei Bobrov 2012-12-5
one way
M - your data matrix with 4 columns < Year Month Day data > - double type
[a,~,c] = unique(M(:,1:2),'rows');
out = [a, accumarray(c,M(:,4),[],@mean)];
Chad Greene
Chad Greene 2014-11-5
downsample_ts can do this by
precip_monthlymean = downsample_ts(precip_daily,t_daily);
  2 个评论
ABDULLA RAHIL
ABDULLA RAHIL 2016-8-25
Hi Chad I tried to use this equation but i couldn't i have a daily data and want to have monthly data
Chad Greene
Chad Greene 2016-8-31
My mistake--
precip_monthlymean = downsample_ts(precip_daily,t_daily,'monthly','mean');

请先登录，再进行评论。

Babak
Babak 2012-12-5
Every 30 data rows, I would average them out and save it in 1 row.This way, 30 days shrinks down to 1 data (a month). Or another way, you can simply delete 29 data rows and keep only one from every 30 data rows.
  2 个评论
Mohammad
Mohammad 2012-12-5
Thanks. But please provide answer through matlab function.
Babak
Babak 2012-12-5
you need to write what your variables are and we would know which format they are... I mean what type they are for example, string? double, or cell? moreover they are all in a matrix or a cell or how you ahev sorted them..

请先登录，再进行评论。

per isakson
per isakson 2012-12-5
编辑：per isakson 2012-12-5
Given thirty days in every month try this
daily_val = rand( 30*12, 1 );
daily_val = reshape( daily_val, 30, [] );
monthly_val = sum( daily_val, 1 );
here I assume that the first value in daily_val is the first value of a month. This is intended as a start.
ABHILASH SINGH
ABHILASH SINGH 2020-3-13

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by