MATLAB Answers

How to remove outliers based on datetime

1 view (last 30 days)
Bluegin
Bluegin on 5 Mar 2020
Answered: J. Alex Lee on 5 Mar 2020
Hi,
I am wondering how to remove outliers based on datetime values in Matlab. For example, in the table below, I am looking for a way to simply remove the first and last row because the values of t.time for those rows are very different from the other values.
time = {"2017-01-12 09:50:46" ...
"2017-06-15 13:50:46" ...
"2017-06-15 14:50:50" ...
"2017-06-15 17:52:06" ...
"2017-06-15 18:52:22" ...
"2017-06-16 11:52:22" ...
"2017-11-19 09:52:22"}'
t = cell2table(time)
t.time = datetime(t.time, 'InputFormat', 'yyyy-MM-dd HH:mm:ss')
t.val1 = (1:7)'
t.val2 = (8:14)'
Thank you,

  0 Comments

Sign in to comment.

Answers (1)

J. Alex Lee
J. Alex Lee on 5 Mar 2020
What if you ran statistics on real or integer representations of datetime, using datenum() or something?

  0 Comments

Sign in to comment.

Sign in to answer this question.

Tags


Translated by