MATLAB: How to smooth datetime type of array?

datetime

i have request and response time od mobile users and want to calculate the elapsed time for that i need to smooth the the time.i have tried moving avg smoother its not working as it is Datetime

Best Answer

Let D be your datetime array. Then

D_diff_dur = diff(D);
diff_days = datenum(D_diff);
smooth_diff_days = smooth(diff_days);
smooth_diff_dur = days(smooth_diff_days);
smoothed_D = D(1) + smooth_diff_dur;

This can all be combined into one expression.

Related Solutions

MATLAB: Interpolation of in-between values in a list of different groups

I've not tried to understand your code to see where the slow processing is (edit: it's probably the stack) There's no reason for this processing to be slow.

Here is how I'd do it. The splitapply could be replaced by an explicit loop which may even be faster:

% Get query vector for interpolation.
days_queried = (1:100)';
%find unique date and assign unique ID to rows of the table
[rowid, date] = findgroups(zerocd.date); %or [date, ~, rowid] = unique(zerocd.data);  %if using unique
%interpolate relevant rows for each unique day
%with splitapply, output a scalar cell array containing a column vector of interpolated rate for each day.
daily_zerocd = splitapply(@(inday, inrate) {interp1(inday, inrate, days_queried, 'linear', 'extrap')}, zerocd.days, zerocd.rate, rowid);
%stuff it all in a table
Interpolated = table(repelem(date, numel(days_queried)), repmat(days_queried, numel(date), 1), vertcat(daily_zerocd{:}), ...
                     'VariableNames', {'date', 'days', 'rate'})

MATLAB: Summing parts of an array?

sum(D(1:8))

Best Answer

Related Solutions

MATLAB: Interpolation of in-between values in a list of different groups

MATLAB: Summing parts of an array?

Related Question