conversion of daily cell into monthly cell.

1 view (last 30 days)
hi,for me this is little hard to explain please try to understand have created on the cell.(attached) it contains hourly wind data (direction and speed) against each day.
<24x2 double> 736055
<24x2 double> 736056
<24x2 double> 736057
<24x2 double> 736058
now I want to create a cell which will contain hourly wind data (direction and speed) against each month.
I don't want to average. I want to append wind data after each 24 hours for each month.
i hope you understand

Accepted Answer

Andrei Bobrov
Andrei Bobrov on 25 Oct 2016
Edited: Andrei Bobrov on 25 Oct 2016
[Y,M] = datevec([day_wise_wind_chembur{:,2}]');
[a,~,c] = unique([Y,M],'rows');
out = [num2cell(a,2),...
accumarray(c,(1:numel(c))',[],@(ii){cell2mat(day_wise_wind_chembur(ii,1))})];

More Answers (1)

Marc Jakobi
Marc Jakobi on 25 Oct 2016
Edited: Marc Jakobi on 25 Oct 2016
Use vertical concatenation.
month = [day1; day2; day3; ...; day31];
% day1 through day31 would be the variables containing the 24x2 doubles
To store the months in the cell array
C{1} = [day1; day2; day3; ...; day4];

Categories

Find more on Dates and Time in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!