Importing data with date and time columns
2 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
採用された回答
Star Strider
2016 年 6 月 29 日
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 件のコメント
Star Strider
2016 年 6 月 29 日
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)
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Data Import from MATLAB についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!