How to create a table with a timedate

10 次查看（过去 30 天）
J.FENG
J.FENG 2023-4-6
评论： Star Strider 2023-4-6
I am trying to create table like with a column which shows the date from 2022-6-1 to 2022-9-26, and the row shows the time at 21h, 24h,3h,6h,9h,12h,15h,18h like the excel I draw below.
Here is my code, but it doesn't works fine
dates = datetime('2022-06-01'):days(1):datetime('2022-09-26');
times = {'21h', '24h', '3h', '6h', '9h', '12h', '15h', '18h'};
table_data = zeros(length(dates), length(times));
T = array2table(table_data, 'RowNames', times, 'ColumnNames', string(dates));

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

采纳的回答

Star Strider
Star Strider 2023-4-6
编辑：Star Strider 2023-4-6
Ran in:
Try this —
dates = datetime('2022-06-01'):days(1):datetime('2022-09-26');
times = {'21h', '24h', '3h', '6h', '9h', '12h', '15h', '18h'};
varTypes = {'double' 'double' 'double' 'double' 'double' 'double' 'double' 'double'}; % Change This As Necessary
T = table('Size',[numel(dates),numel(times)], 'VariableTypes',varTypes, 'VariableNames',times, 'RowNames',cellstr(dates.'))
T = 118×8 table
21h 24h 3h 6h 9h 12h 15h 18h ___ ___ __ __ __ ___ ___ ___ 01-Jun-2022 0 0 0 0 0 0 0 0 02-Jun-2022 0 0 0 0 0 0 0 0 03-Jun-2022 0 0 0 0 0 0 0 0 04-Jun-2022 0 0 0 0 0 0 0 0 05-Jun-2022 0 0 0 0 0 0 0 0 06-Jun-2022 0 0 0 0 0 0 0 0 07-Jun-2022 0 0 0 0 0 0 0 0 08-Jun-2022 0 0 0 0 0 0 0 0 09-Jun-2022 0 0 0 0 0 0 0 0 10-Jun-2022 0 0 0 0 0 0 0 0 11-Jun-2022 0 0 0 0 0 0 0 0 12-Jun-2022 0 0 0 0 0 0 0 0 13-Jun-2022 0 0 0 0 0 0 0 0 14-Jun-2022 0 0 0 0 0 0 0 0 15-Jun-2022 0 0 0 0 0 0 0 0 16-Jun-2022 0 0 0 0 0 0 0 0
.
  4 个评论
显示 2更早的评论

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Calendar 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by