How to select rows with NaT values ?
16 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Namrata Goswami
el 27 de En. de 2021
Comentada: Namrata Goswami
el 29 de En. de 2021
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 comentarios
Respuesta aceptada
Walter Roberson
el 27 de En. de 2021
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)
Más respuestas (0)
Ver también
Categorías
Más información sobre Logical en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!