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

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.

[Sindar]

check out the Import Tool and have it generate code for you: https://www.mathworks.com/help/matlab/import_export/import-data-interactively.html

[Adilla Zulkifli]

Thank you. I already got the solution for the problem.

Answer 1

[Dinesh Yadav]

Go through the following links to see how to fill in missing dates as well as missing data.

https://www.mathworks.com/matlabcentral/answers/373731-add-missing-time-data

https://www.mathworks.com/matlabcentral/answers/262492-incomplete-time-series-fill-missing-dates-with-nans

https://www.mathworks.com/help/matlab/ref/fillmissing.html

https://www.mathworks.com/matlabcentral/answers/167799-inserting-missing-dates-and-values

[Adilla Zulkifli]

Thank you for your suggestions. I already got the solution for the problem.