How to select rows with NaT values ?

Question

0 个投票

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!

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

Answer 1

Walter Roberson 2021-1-27

0 个投票

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)

Namrata Goswami 2021-1-29

Thank you.