Import Hours from .csv without colon
조회 수: 2 (최근 30일)
이전 댓글 표시
I have a time series data set that I need to import into Matlab. The hour time data are in the following format: 30 100 130 200 ...
I cannot get Matlab to recognize all of the hour values because there is no delimiting colon and the variation in the number of characters (two characters for 30, and up to 4 characters for 1000 for example).
Any suggestions?
댓글 수: 2
답변 (1개)
Pieter Hamming
2018년 6월 20일
편집: Pieter Hamming
2018년 6월 20일
Lets say D is a column-array of your data:
D=[30;100;1200;330];
All digits before the last 2 are hours, so lets extract them:
hours=floor(D./100); %for our example data: hours=[0;1;12;3];
Substract the hours from the original data to have only the minutes left:
minutes=D-hours.*100; %for our example data: minutes=[30;0;0;30];
Either you're done now, or you can make a duration array out of it: dur=duration(hours,minutes,0);
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Whos에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!