How to convert daily data to monthly?
16 views (last 30 days)
Show older comments
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 Comments
per isakson
on 5 Dec 2012
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?
Answers (5)
Andrei Bobrov
on 5 Dec 2012
Edited: Andrei Bobrov
on 5 Dec 2012
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)];
0 Comments
Chad Greene
on 5 Nov 2014
downsample_ts can do this by
precip_monthlymean = downsample_ts(precip_daily,t_daily);
2 Comments
ABDULLA RAHIL
on 25 Aug 2016
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
on 31 Aug 2016
My mistake--
precip_monthlymean = downsample_ts(precip_daily,t_daily,'monthly','mean');
Babak
on 5 Dec 2012
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 Comments
Babak
on 5 Dec 2012
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
on 5 Dec 2012
Edited: per isakson
on 5 Dec 2012
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.
0 Comments
See Also
Categories
Find more on Dates and Time 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!