How to remove outliers based on datetime
2 views (last 30 days)
Show older comments
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
Answers (1)
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
See Also
Categories
Find more on Calendar in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!