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

2 次查看（过去 30 天）
Adilla Zulkifli
Adilla Zulkifli 2020-3-9
评论： Adilla Zulkifli 2020-3-12
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.

请先登录，再回答此问题。

回答（1 个）

Dinesh Yadav
Dinesh Yadav 2020-3-12

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by