How to fix the missing patches that turn into NAT?

2 次查看（过去 30 天）
Arqam R
Arqam R 2019-6-13
回答： Peter Perkins 2019-6-13
Missing time and date as NAT after importing large data from excel in table format! NOT ALL but some data is missing at different patches although the whole excel file contains same date and time format column. How to fix the missing patches that turn into NAT?
  2 个评论
KSSV
KSSV 2019-6-13
YOu can generate the dates manually..if you know the time sampling.
Arqam RAfi
Arqam RAfi 2019-6-13
I have a very large data (one min resolution) for 2 years x 22 and looking for a short cut here.

请先登录，再进行评论。

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

回答（2 个）

Steven Lord
Steven Lord 2019-6-13
The fillmissing and/or retime functions (retime if you're storing your data as a timetable, fillmissing if your data is a vector, table, or timetable) may be of use.
Peter Perkins
Peter Perkins 2019-6-13
It's possible that what's happening is that your timestamps are stored in the spreadsheet file as text, not as dates, and that some of them are exactly at midnight, and lack hh:mm:ss.
It's also possible that you just have junk in some of the cells in your spreadsheet. You needm to post a small example, including how you are reading the file.

类别

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

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by