How to fix the missing patches that turn into NAT?
조회 수: 2 (최근 30일)
이전 댓글 표시
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
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
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.
댓글 수: 0
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.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!