How to remove outliers based on datetime

5 visualizaciones (últimos 30 días)
012786534
012786534 el 5 de Mzo. de 2020
Respondida: J. Alex Lee el 5 de Mzo. de 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,

Respuestas (1)

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

Categorías

Más información sobre Calendar en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by