Missing data with a time range
2 views (last 30 days)
Show older comments
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:)
0 Comments
Accepted Answer
More Answers (0)
See Also
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!