Importing data with date and time columns

Question

David du Preez 2016-6-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/292989-importing-data-with-date-and-time-columns

评论： Star Strider 2016-6-29

I have a large data set in excel. In column A are dates(2015-01-01) and in column B are times(0:00).How do I import this into Matlab?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2016-6-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/292989-importing-data-with-date-and-time-columns#answer_227154

在 MATLAB Online 中打开

Import it using the xlsread function.

I assume you already knew that, and want to know how to combine the date and time strings to create a valid date number. You can take advantage of the fact that MATLAB uses square brackets [] to concatenate strings.

Something like this will work:

dt = '2015-01-01';
tm = '12:34';
dn = datenum([dt tm], 'yyyy-mm-ddHH:MM')
ds = datestr(dn)                                 % Check Conversion (Optional)
ds =
01-Jan-2015 12:34:00

2 个评论
显示无隐藏无

David du Preez 2016-6-29

Book1.xlsx

I have tried that and it still doesn't work. When I use the xlsread function to import the data. Matlab ignores column A. Attached is a sample of the data and it continues like that for the rest of the year.

Star Strider 2016-6-29

在 MATLAB Online 中打开

This works:

[d,s] = xlsread('David du Preez Book1.xlsx');
dn = datenum(s(2:end,1), 'mm/dd/yyyy') + d(:,1);
ds = datestr(dn)                                 % Check Conversion (Optional)

请先登录，再进行评论。