MATLAB: Daily max -min , sum, average of hourly data sets.

averagemaxminsum

hi,

I have created one mat file (attached). the first column is dates the second column is temperature- here I want to find daily max and min the third column is rainfall- here daily sum I don't need 4th and 5th column but for this time make an average.

in the date column, time is not given but it is an hourly data.(same date 24 times.)

i hope you understand

Best Answer

[y,m,d] = datevec(tempdata(:,1));
[a,~,c] = unique([y,m,d],'rows');
out = [a, zeros(size(a,1),7)];
out(:,4) = accumarray(c,tempdata(:,2),[],@nanmin);
out(:,5) = accumarray(c,tempdata(:,2),[],@nanmax);
out(:,6) = accumarray(c,tempdata(:,3),[],@nansum);
[ii,jj] = ndgrid(c,1:4);
out(:,7:10) = accumarray([ii(:),jj(:)],reshape(tempdata(:,4:7),[],1),[],@nanmean);

Related Solutions

MATLAB: How calculate daily, monthly, seasonally mean average and std

I would recommend storing the data as timetable variable, and applying retime function.

The following is an example:

% Load data file
load('Date1Time1Data1.mat');
% Create datetime array
Time = datetime(...
  Date1Time1Data1(:,3),Date1Time1Data1(:,2),Date1Time1Data1(:,1),...
  Date1Time1Data1(:,4),Date1Time1Data1(:,5),Date1Time1Data1(:,6));
% Arrange data array to timetable variable
TT = array2timetable(Date1Time1Data1(:,7:end),'RowTimes',Time);
% Example1: daily average
TT_da = retime(TT,'daily','mean');
% Example2: montly std
TT_ms = retime(TT,'monthly',@std);

MATLAB: Variable TempData must be of size [25 33]. It is currently of size [31 24]. Check where the variable is assigned a value.

You cannot do that.

After reducing by 1 row, your data ended up with 31 rows. Therefore it had 32 rows to start.

After reducing by 2 columns, your data ended up with 24 columns. Therefore it had 26 columns to start.

Suppose we take

TempData = readmatrix ("Clemson_Temp.xlsx") .';    %NOTICE THE TRANSPOSE

then TempData would be 26 rows and 32 columns (after the transpose.)

You can remove one row from that,

TempData = Tempdata(32:end,:);

and the result would be 25 rows and 32 columns. Which is close, but you need it to be 25 rows and 33 columns. You cannot "invent" the missing 33rd entry.

I suspect that the input had 33 rows but that the first row was interpreted as being a header and so was discarded by readmatrix. If you have reason to believe that the first row is valid data, then try

TempData = readmatrix("Clemson_Temp.xlsx", 'NumHeaderLines', 0) .';    %NOTICE THE TRANSPOSE
TempData = TempData(2:end,:);

Best Answer

Related Solutions

MATLAB: How calculate daily, monthly, seasonally mean average and std

MATLAB: Variable TempData must be of size [25 33]. It is currently of size [31 24]. Check where the variable is assigned a value.

Related Question