Date numbers in double to datestring matrix

2 次查看（过去 30 天）
Evan Watts
Evan Watts 2018-4-25
评论： Peter Perkins 2018-4-26
I have a 31x3 double with the first column being date serial numbers from low to high, and the next 2 columns being X an Y. I would simply like to create a matrix that is more user friendly, so that someone can click on it and see actual date strings corresponding with the X and Y values. Is there any effective way of doing this? I have been battling with datestr, as it doesn't like putting things back into a double. Thoughts?

请先登录，再回答此问题。

采纳的回答

njj1
njj1 2018-4-25
You cannot put date strings and numerical data into a single matrix. You could use a cell if you wanted. For example:
X_new{1,1} = datestr(X_old(:,1)); %first cell array is the date strings
X_new{1,2} = X_old(:,2:end); %second cell is the X,Y data matrix
  1 个评论
Peter Perkins
Peter Perkins 2018-4-26
You will be much happier with a table or (in R2016b or later) a timetable than with a cell array. You'll also be happier if you use datetimes rather than datenums and datestrs.

请先登录，再进行评论。

更多回答（1 个）

Steven Lord
Steven Lord 2018-4-25
If you're using release R2016b or later, consider representing your times as a datetime vector and storing your data in a timetable with that datetime vector as its time vector.

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by