How to select rows with NaT values ?
조회 수: 20 (최근 30일)
이전 댓글 표시
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
채택된 답변
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!