How to fill in the missing dates along with NaN values in an input data format text file?

7 Ansichten (letzte 30 Tage)
Hello,
I have an input data in format text file (.txt) consists of date (year month DoY), northing, easting and up. The data is in daily solution for a period of 18 years (~6570 days) but some of the data has missing dates and not shown in the input file. How do I fill in the missing dates along with the NaN values for northing, easting and up components in the input file?
The format of my input data is as follows:
2007 9 265 5.8683228424232565 -8.0854320194954923 -10.9392468817532060
2007 9 267 5.5668915479748442 -8.0822003412263879 -11.4714466966688630
2007 9 268 5.7461423352735448 -8.2947078512281927 -10.1020627655088900
expected output:
2007 9 265 5.8683228424232565 -8.0854320194954923 -10.9392468817532060
2007 9 266 NaN NaN NaN
2007 9 267 5.5668915479748442 -8.0822003412263879 -11.4714466966688630
2007 9 268 5.7461423352735448 -8.2947078512281927 -10.1020627655088900
I hope somebody can help me.
Thank you.

Antworten (1)

Dinesh Yadav
Dinesh Yadav am 12 Mär. 2020

Kategorien

Mehr zu Time Series Objects finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by