How to filter a table with a date field

Question

Manny 2024-2-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2083683-how-to-filter-a-table-with-a-date-field

评论： Dyuman Joshi 2024-2-19

Hi everyone

I have an n by m table called Table1 that needs to be filtered. I am new to Matlab so I am learning as I go. I need to return all the rows in Table1 when TRADE_DATE <= Feb 16 2024. How do I this? Thank you

    SYMBOL     TRADE_DATE     
    _______    ___________    
    {'SPX'}    03-Jun-2014                         
    {'SPX'}    09-Jun-2014                       
    {'SPX'}    10-Jun-2014                         

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Dyuman Joshi 2024-2-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2083683-how-to-filter-a-table-with-a-date-field#answer_1411428

在 MATLAB Online 中打开

You can directly compare dates and use logical indexing to get the corresponding data -

%date to compare
dt = datetime(2014, 2, 16);
%Data
vec = table(rand(4,1), datetime(2014, 2, [11 13 17 19]).')
vec = 4×2 table
      Var1         Var2    
    ________    ___________

     0.33292    11-Feb-2014
     0.52272    13-Feb-2014
    0.095657    17-Feb-2014
     0.95912    19-Feb-2014
idx = vec{:,2}<=dt
idx = 4×1 logical array
   1
   1
   0
   0
out = vec(idx, :)
out = 2×2 table
     Var1         Var2    
    _______    ___________

    0.33292    11-Feb-2014
    0.52272    13-Feb-2014