Why 'NaT' (class: datetime) does not work with find function?
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Struggling in MATLAB
am 1 Jul. 2022
Kommentiert: Star Strider
am 1 Jul. 2022
I have a table part of which is attached. The enries in the date column are as datetime. I am trying to get the id where the entry for date is NaT. When I use find function for regular dates such as,
idx = ans.id(find(ans.date == '19-Apr-2022'));
I get an output. But the same does not work for NaT.
idx = ans.id(find(ans.date == 'NaT'));
It gives me empty array. What might be the problem?
0 Kommentare
Akzeptierte Antwort
Weitere Antworten (1)
Steven Lord
am 1 Jul. 2022
The reason why isnat works and your == call did not is because NaT is like NaN -- it is not equal to anything, not even another NaT or NaN. It is not even equal to itself.
x = [1 NaN 2]
x == x
isequal(x, x)
y = [NaT datetime('today')]
y == y
isequal(y, y)
You will need to identify the NaT values with isnat or ismissing.
isnat(y)
ismissing(y)
Alternately you could use isequaln if you want to detect if two arrays (potentially containing NaT) are equal. isequaln behaves like isequal except it considers missing values equal to missing values.
isequaln(y, y)
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!