MATLAB Answers

How to fix the missing patches that turn into NAT?

6 views (last 30 days)
Arqam R
Arqam R on 13 Jun 2019
Answered: Peter Perkins on 13 Jun 2019
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 Comments

KSSV
KSSV on 13 Jun 2019
YOu can generate the dates manually..if you know the time sampling.
Arqam RAfi
Arqam RAfi on 13 Jun 2019
I have a very large data (one min resolution) for 2 years x 22 and looking for a short cut here.

Sign in to comment.

Answers (2)

Steven Lord
Steven Lord on 13 Jun 2019
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.

  0 Comments

Sign in to comment.


Peter Perkins
Peter Perkins on 13 Jun 2019
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.

  0 Comments

Sign in to comment.

Sign in to answer this question.

Products


Release

R2018a

Translated by