Combine date vector into single column
5 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a n X 6 matrix, with time data:
1st col = yyyy (e.g. 2016)
2nd col = mm (e.g. 10 for Oct)
3rd col = day (e.g. 1)
4th col = hour
5th col = min
6th col = seconds
I need to combine them into a n X 1 (e.g. 1-Oct-2016 00:00:00). How can I do that?
My initial data comes in the form of serial date (e.g. 4.264400001156250e+04 for 1-Oct-2016 00:00:00)
I used this function to convert into a date vector, but am stuck from here:
date_vec = datevec(datestr(x2mdate(raw_data)));
Should I be doing this? My goal is to export to excel for it to be read properly (need to plot a time series). Currently when it goes to the next day, instead of showing up the date of the next day, it simple wraps back to AM of the same day.
e.g.
42644.99999
42644.99999
42645
42645
2 commentaires
Réponses (2)
the cyclist
le 13 Jan 2017
Would something like this work?
raw_data = [2016 10 1 3 45 50;
2017 1 1 4 15 20]
arrayfun(@datestr,datenum(raw_data),'UniformOutput',false)
5 commentaires
Stephen23
le 15 Jan 2017
Modifié(e) : Stephen23
le 15 Jan 2017
"I need to convert into such a format -> 01-Oct-2016 00:00:00 and store it into the first column of a matrix A ( type double)."
A string with multiple characters has multiple columns (one per character), so cannot be put into one column of another matrix, unless that other matrix is a cell array. You could store this string in a character array (with multiple columns) or a cell array (with one column), but certainly not in a numeric array with one column. Not unless you convert it to a serial date number first.
Peter Perkins
le 19 Jan 2017
Unless you're using a version of MATLAB older than R2014b, you should be using datetimes:
>> datetime(4.264400001156250e+04,'ConvertFrom','Excel')
ans =
datetime
01-Oct-2016 00:00:00
3 commentaires
Peter Perkins
le 17 Fév 2019
The literal answer is timeofday, subtraction, and some form of convertTo, but you probably DON'T actually want to do that. Unless yu have a specific reason, stick with datetimes.
Also, it's considered bad form to tack a completely unrelated question on the end of a two-year-old thread.
Steph
le 18 Fév 2019
Yes Peter you are right, but I thought it was related to the original question, as I also have each element of date time seperately (6 arrays) and was trying to get 2 different columns one for each date and time.
I will open a new thread if I can not find the answer I am looking for.
Tnx.
Voir également
Catégories
En savoir plus sur Time Series Objects dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!