MATLAB Answers

How to select rows with NaT values ?

조회 수: 5(최근 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)
  댓글 수: 1
Namrata Goswami
Namrata Goswami 2021년 1월 29일
Thank you.

댓글을 달려면 로그인하십시오.

추가 답변(0개)

Community Treasure Hunt

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

Start Hunting!

Translated by