How to create a table with a timedate
8 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1347379/image.png)
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 Commenti
Risposta accettata
Star Strider
il 6 Apr 2023
Modificato: Star Strider
il 6 Apr 2023
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.'))
.
4 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!