MATLAB Answers

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

11 views (last 30 days)
Adilla Zulkifli
Adilla Zulkifli on 9 Mar 2020
Commented: Adilla Zulkifli on 12 Mar 2020
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.

Answers (1)

Dinesh Yadav
Dinesh Yadav on 12 Mar 2020

Community Treasure Hunt

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

Start Hunting!