Add datetime vector which contains NaT to double
4 views (last 30 days)
Show older comments
I have a 2546x7200 matrix and I would like to add a vector of datetimes to the first column. The first row of the matrix is frequency values, the first column would be datetimes, and the cells filled with decibel values. However, since the first row of the datetime vector is NaT, I get an error when I try to append it. How could I overcome this? Thanks!
I tried:
A=cat(2,t,output_plot);
%where t is datetime vector and output_plot is the double matrix
0 Comments
Answers (1)
Eric Sofen
on 9 Jun 2020
The NaT isn't the problem. You cannot concatenate datetime and double in a homogenous matrix:
>> x = [1 2 datetime('now')]
Error using datetime/horzcat (line 1387)
All inputs must be datetimes or date/time character vectors or date/time strings.
Either store the data in a table/timetable, which is intended to store variables of different types but the same height, or decide how you want to convert the datetime into something that can be represented as a double (i.e. if all you needed was hour-of-the-day, you could extract that), although that loses the datetime functionality.
0 Comments
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!