Importing data with date and time columns
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
David du Preez
le 29 Juin 2016
Commenté : Star Strider
le 29 Juin 2016
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 commentaires
Réponse acceptée
Star Strider
le 29 Juin 2016
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 commentaires
Star Strider
le 29 Juin 2016
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)
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB 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!