How to filter a table with a date field
11 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Manny
am 19 Feb. 2024
Kommentiert: Dyuman Joshi
am 19 Feb. 2024
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 Kommentare
Akzeptierte Antwort
Dyuman Joshi
am 19 Feb. 2024
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]).')
idx = vec{:,2}<=dt
out = vec(idx, :)
2 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Dates and Time finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!