How to remove outliers based on datetime

조회 수: 5 (최근 30일)
012786534
012786534 2020년 3월 5일
답변: J. Alex Lee 2020년 3월 5일
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,

답변 (1개)

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

카테고리

Help CenterFile Exchange에서 Calendar에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by