MATLAB: How to calculate hourly average value for measured Temperature, CO2, RH and Rid in 5 minutes interval

hourly average valueMATLAB

Hello all.

Hopfully you all stay well and safe.

I have Temperature, CO2, RH and Rid measured each 5 minutes interval for about 36 days, (from 09/04/2020 to 14/05/2020) about 10080 rows in total. From these data I need to calculate the hourly average value for these measured Temperature, CO2, RH and Rid which means that eventually I must have 24 hourly averaged values per day.

I would appreciate any ideas on the matter!

I have attached the excel file I'm working on.

Regards

Best Answer

The loop below breaks up you time stamps into hours and creates a new vector with the mean value for each hour of the provided data.

Temp = data1(:,4);
i = 12:12:840;
for k = 1:length(i)
    DailyAvg(k) = mean(Temp((i(k)-11):i(k)));
end

Related Solutions

MATLAB: Calculate minutes average values

I would import the spreadsheet as a table, then convert the day and time into a datetime, convert that to a timetable, and use the retime function to combine the data into 1 minute and 5 minute increments.

data = readtable("Book_Jan.xlsx");
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.
% Convert DAY and TIME into durations
data.DAY = days(data.DAY);
data.TIME = days(data.TIME);
% Create a datetime
data.TimeStamp = datetime(2014,01,01) + data.DAY-1 + data.TIME;
data.TimeStamp.Format = "MM-dd-yy HH:mm";
% Convert the table to a timetable
dataTT = table2timetable(data,"RowTimes","TimeStamp");
% Use retime to average the data into 1 and 5 minute increments.
dataTT1min = retime(dataTT(:,["VTEC" "S4" "Sigma"]),"minutely","mean")
dataTT1min = 44636x3 timetable
      TimeStamp        VTEC        S4        Sigma  
    ______________    ______    ________    ________

    01-01-14 00:04    9.4936    0.051653    0.037328
    01-01-14 00:05    15.034    0.053267    0.044752
    01-01-14 00:06    10.191      0.0471    0.037384
    01-01-14 00:07    12.139    0.071698    0.045127
    01-01-14 00:08       NaN         NaN         NaN
    01-01-14 00:09    15.691    0.054704    0.043895
    01-01-14 00:10    3.8546    0.039522    0.035422
    01-01-14 00:11    13.002    0.068763    0.040811
    01-01-14 00:12    15.675    0.090359    0.045485
    01-01-14 00:13       NaN         NaN         NaN
    01-01-14 00:14    10.517    0.044855    0.038009
    01-01-14 00:15    12.454    0.053156     0.03739
    01-01-14 00:16    10.704    0.052649    0.036479
    01-01-14 00:17    2.0486     0.05072    0.049246
    01-01-14 00:18    8.1786    0.041343    0.036154
    01-01-14 00:19       NaN         NaN         NaN
dataTT5min = retime(dataTT(:,["VTEC" "S4" "Sigma"]),"regular","mean","TimeStep",minutes(5))
dataTT5min = 8928x3 timetable
      TimeStamp        VTEC        S4        Sigma  
    ______________    ______    ________    ________

    01-01-14 00:00    9.4936    0.051653    0.037328
    01-01-14 00:05    12.902    0.058996    0.042836
    01-01-14 00:10     11.94    0.065468     0.04091
    01-01-14 00:15    9.2135     0.04967    0.038829
    01-01-14 00:20     6.063    0.046863    0.036622
    01-01-14 00:25    8.6923    0.084346    0.038214
    01-01-14 00:30    14.037    0.067668    0.036141
    01-01-14 00:35    15.687    0.069287    0.044902
    01-01-14 00:40    16.367     0.06382     0.04569
    01-01-14 00:45    14.388    0.046352    0.037041
    01-01-14 00:50    16.051    0.050894    0.031428
    01-01-14 00:55    15.175    0.048557    0.032849
    01-01-14 01:00    19.772    0.066493     0.03821
    01-01-14 01:05    17.465    0.076747    0.045897
    01-01-14 01:10    19.234    0.062305    0.039331
    01-01-14 01:15    17.724    0.055996    0.039595

MATLAB: Create a time table from specific time date format

The format is not an issue but there are several ways to import. Here is one:

opts = detectImportOptions('data.txt');
opts = setvartype(opts, 'char');
tbl = readtable('data.txt',opts);
C=strcat(tbl.Date, {' '}, tbl.Time)
datetime(C,'inputformat','yyyyMMdd HHmmSS')

You can also experiment a bit more with the detectImportOptions to avoid post-processing

opts = detectImportOptions('data.txt');
opts = setvartype(opts,'Date','datetime');
opts = setvartype(opts,'Time','datetime');
opts = setvaropts(opts,'Date','InputFormat','yyyyMMdd')
opts = setvaropts(opts,'Time','InputFormat','HHmmss')
T = readtable('data.txt',opts)

Best Answer

Related Solutions

MATLAB: Calculate minutes average values

MATLAB: Create a time table from specific time date format

Related Question