# Find missing dates in dataset and make observations NaN?

2 visualizzazioni (ultimi 30 giorni)
Daphne PARLIARI il 8 Gen 2021
Commentato: Daphne PARLIARI il 11 Gen 2021
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?
PS. I am on 2019a.
##### 0 CommentiMostra -2 commenti meno recentiNascondi -2 commenti meno recenti

Accedi per commentare.

### Risposta accettata

Cris LaPierre il 8 Gen 2021
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 CommentoMostra -1 commenti meno recentiNascondi -1 commenti meno recenti
Daphne PARLIARI il 11 Gen 2021
Thanks for the help!
In case anyone finds it helpful, here is the code that solved my problem:
m=1;
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);
m=m+1;
end
end

Accedi per commentare.

### Categorie

Scopri di più su Dates and Time in Help Center e File Exchange

### Community Treasure Hunt

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

Start Hunting!

Translated by