MATLAB: Is there a way to calculate the mean of multiple data points at one time stamp of a time series

time series time stamps mean

I have a data set where for a number of time stamps, multiple data points are measured. Is there a way to calculate the mean of a time series at every timestamp? In the series, the first column are the timestamps and the second column are the measurements.

Best Answer

Depending on what you have, it can be as easy as

   retime(tt,tt.Time,'mean');

where tt is a timetable.

Related Solutions

MATLAB: Add date stamp to time stamp

Here's how I'd do it. Whatever you do don't use outdated datenum and datestr. Stay with datetime and duration arrays.

[h, m, s] = hms(HRV_BB3.Time(end));  %extract hours, minutes and seconds from last time (actually a datetime whose date is wrong)
enddate = datetime(2018,5,21,h,m,s)  %calculate the right datetime
HRV_BB3.DateTime = enddate + [cumsum(-mod(diff(HRV_BB3.Time), hours(24)), 'reverse'); 0];  %calculate difference between consecutive dates, modulo 24h, and add that back

Done!

This assumes of course that days aren't skipped. But since you've lost that information, there's no way to know.

MATLAB: Converting data from minutes to hours

>> data_minute = rand(180, 1);  % synthetic data
>> data_hour = mean(reshape(data_minute, 60, []))

Best Answer

Related Solutions

MATLAB: Add date stamp to time stamp

MATLAB: Converting data from minutes to hours

Related Question