清空筛选条件
清空筛选条件

Import Hours from .csv without colon

3 次查看（过去 30 天）
Grant Lockridge
Grant Lockridge 2018-6-20
编辑： Pieter Hamming 2018-6-20
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 个评论
Stephen23
Stephen23 2018-6-20
What does 30 represent? What does 1000 represent?
Grant Lockridge
Grant Lockridge 2018-6-20
time of day. 30 would be the equivalent of 00:30, 1000 would be 10:00. Additionally, 1300 would be 13:00 and 2100 would be 21:00

请先登录，再进行评论。

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

回答（1 个）

Pieter Hamming
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);

类别

在 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