Missing data with a time range

1 visualizzazione (ultimi 30 giorni)
drb17135
drb17135 il 26 Feb 2021
Risposto: Steven Lord il 26 Feb 2021
Hi,
so I have a timetable including a column of time values each with a corresponding value of numerical values,
for example:
'01-Sep-2020 00:15:00' 7.300
'01-Sep-2020 00:20:00' 8.640
'01-Sep-2020 00:25:00' 7.650
'01-Sep-2020 00:30:00' 8.870
'01-Sep-2020 00:35:00' 7.717
However, I also am missing 3 sets of data, the following:
'28-Sep-2020 13:35:00'
'28-Sep-2020 13:40:00'
'28-Sep-2020 13:45:00'
If I was missing values that said NaN/NaT I would have looked to replace them using filemissing(X,'previous')
However, because there is technically no gaps in my data I am unsure how I can create 3 rows in my timetable where the missing dates are and insert a value to make up for the missing data.
Does anyone have any idea?
Thank you in advance:)

Risposta accettata

Steven Lord
Steven Lord il 26 Feb 2021
retime your timetable to a regular time basis.

Più risposte (0)

Categorie

Scopri di più su Tables 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