Find missing dates in dataset and make observations NaN?

조회 수: 6 (최근 30일)
Daphne PARLIARI . 2021년 1월 8일
댓글: Daphne PARLIARI . 2021년 1월 11일
Hello and happy new year!
I have a dataset (see attached) with daily values of temperature from 2013 to 2016 . Column Daily_DATE contains the dates fow which I actually had a value for temperature, NaT indicates days with no observation. Column Time_Seq_Full contains all dates from 01-Jan-2013 to 31-Dec-2016.
Is there any way I can display the dates from Time_Seq_Full that doesn't correspond to a date in Daily_DATE (AKA find the missing dates), and in the same time make the respective values of Daily_T = NaN?
Thank you in advance!
PS. I am on 2019a.

채택된 답변

Cris LaPierre
Cris LaPierre 2021년 1월 8일
I would think you could use logical indexing to find the rows of Daily_DATE that are equal to NaT. You can then use that index to set the corresponding rows of Daily_T to NaN, and extract the corresponding dates from the rows of Time_Seq_Full.
  댓글 수: 1
Daphne PARLIARI 2021년 1월 11일
Thanks for the help!
In case anyone finds it helpful, here is the code that solved my problem:
for i = 1: length(Daily_Data.Daily_DATE)
if Daily_Data.Daily_DATE(i)~=Daily_Data.Time_Seq_Full(i)
Daily_Data.Daily_T(i) = NaN; Daily_Data.Daily_Tappmax(i) = NaN;
NoData_Dates(m, :) = Daily_Data.Time_Seq_Full(i);

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

추가 답변 (0개)


Help CenterFile Exchange에서 Logical에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by