How to select rows with NaT values ?

24 次查看（过去 30 天）
Namrata Goswami
Namrata Goswami 2021-1-27
评论： Namrata Goswami 2021-1-29
I have a table:
ID StartDate EndDate
12 10/01/2021 12/01/2021
12 19/01/2021 NaT
12 03/01/2021 13/01/2021
12 09/01/2021 NaT
12 10/01/2021 14/01/2021
I'm trying to remove the rows with StartDate <= 10/01/2021 and EndDate == NaT
And the removed rows should go into a new table.
I have tried the following code, but it doesn't work.
NewTable = Table(Table.StartDate <= "10/01/2021" && EndDate == NaT,:);
Also, how to remove the rows meeting these conditions from the original table?
Thanks!

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

采纳的回答

Walter Roberson
Walter Roberson 2021-1-27
NewTable = Table(Table.StartDate <= datetime(2021,01,10) & isnat(EndDate),:);
or if you are okay with removing all NaT including cases where the StartDate does not match that criteria, then
NewTable = rmmissing(Table)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Electrophysiology 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by