Combine date vector into single column
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (2)
the cyclist
el 13 de En. de 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 comentarios
Stephen23
el 15 de En. de 2017
Editada: Stephen23
el 15 de En. de 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
el 19 de En. de 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 comentarios
Peter Perkins
el 17 de Feb. de 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
el 18 de Feb. de 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.
Ver también
Categorías
Más información sobre Time Series Objects en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!