Missing data with a time range

1 view (last 30 days)
drb17135
drb17135 on 26 Feb 2021
Answered: Steven Lord on 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:)

Accepted Answer

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

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!