How to create a table with a timedate

Question

J.FENG 2023-4-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1942539-how-to-create-a-table-with-a-timedate

评论： 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));

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2023-4-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1942539-how-to-create-a-table-with-a-timedate#answer_1210594

编辑：Star Strider 2023-4-6

在 MATLAB Online 中打开

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
21h24h3h6h9h12h15h18h_____________________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 