How to create a table with a timedate
8 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Star Strider
le 6 Avr 2023
Modifié(e) : Star Strider
le 6 Avr 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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!