how to filter data by date?

2024 3 4
2 个回答
回答已采纳
更新时间：2024 3 4
4 次查看（30 天）

0 个投票

hi everyone
I am trying to filter records by date. I am getting error. How do I fix it?
Code:
Data = convertvars(Data, 2, @(x) datetime(x, 'InputFormat', 'yyyy-MM-dd'));
FilteredDataRealizedVol = Data(:,["TRADE_DATE","REALIZED_VOLATILITY"]);
FilteredDataRealizedVol = FilteredDataRealizedVol(FilteredDataRealizedVol(:,1) <= datetime(2016,7,18),:);
FilteredDataRealizedVol = FilteredDataRealizedVol(FilteredDataRealizedVol(:,1) >= datetime(1928,1,27),:);
Error:
Error using <=
This operation is not defined between 'table' and 'datetime'. The input that is not a table or timetable must be a numeric or
logical array.
Error in LinearRegression (line 26)
FilteredDataRealizedVol = FilteredDataRealizedVol(FilteredDataRealizedVol(:,1) <= datetime(2016,7,18),:);
Thank you

请先登录，再回答此问题。

 采纳的回答

Walter Roberson
Walter Roberson 2024-3-4

0 个投票

FilteredDataRealizedVol = FilteredDataRealizedVol(FilteredDataRealizedVol{:,1} <= datetime(2016,7,18),:);

5 个评论
显示 3更早的评论 隐藏 3更早的评论

Manny
Manny 2024-3-4
thanks for the reply. the errors are gone but the array was not filtered. it is still showing the unfiltered data. any idea on what is going on?
Manny
Manny 2024-3-4
i updated the question. i added the second datatime date filter
Dyuman Joshi
Dyuman Joshi 2024-3-4
Use curly brackets for accessing data inside the tables, as Walter has done as well.
Also, see - Access Data in Tables.
Manny
Manny 2024-3-4
i did put the {} but still not working:
FilteredDataRealizedVol = FilteredDataRealizedVol(FilteredDataRealizedVol{:,1} <= datetime(2016,7,18),:);
FilteredDataRealizedVol = FilteredDataRealizedVol(FilteredDataRealizedVol{:,1} >= datetime(1928,1,27),:);
Manny
Manny 2024-3-4
i figured it out now.
the problem was in another part of the code that was referencing the unfiltered data.
thank you everyone for your help!

请先登录，再进行评论。

更多回答（1 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by