Need help with datenum function

Question

Adhi Ariawan 2017-11-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/370029-need-help-with-datenum-function

评论： Star Strider 2017-11-29

image.png

I'm using Matlab R2015b. I have "date" variable ( 178x1 cell ) inside a struct named "data". It consists of one column with multiple rows that consists of dates in dd/mm/yyyy format. Now I'm trying to convert them into numbers using datenum command,

dates = datenum(data.date, 'dd/mm/yyyy');

but it returns me with error.. What am I doing wrong? I've attached a screenshot of what the data looks like. Thanks in advance.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Adhi Ariawan 2017-11-29

Additional note: I noticed I have non-date data on the first row.. How do I treat the first row as NaN data?

请先登录，再进行评论。

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

Answer 1

Star Strider 2017-11-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/370029-need-help-with-datenum-function#answer_293797

Note that the first row is the string ‘date’. The datenum function will fail on that, so start with the second row instead.

4 个评论
显示 2更早的评论隐藏 2更早的评论

Adhi Ariawan 2017-11-29

在 MATLAB Online 中打开

Sorry to bother again, your solution was great, but after using (2:end) I'm facing another problem:

Error using horzcat
Dimensions of matrices being concatenated are not consistent.

I got that error when trying to process the new 'date' with the other data inside of struct. So I was wondering if we can keep the first row as NaN or something. Thanks again.