what is the format of date variable imported from excel

1 次查看（过去 30 天）
xueqi
xueqi 2015-6-27
评论： Peter Perkins 2015-7-6
Hi, I have imported two excels with first column as date and second column as numbers. Then I need to do some manipulation with the two set of data where I am using datenum. Anyway my code is as follows.
% nld=readtable('NLD.xls');
deu=readtable('deu.xls');
corresp = bsxfun( @eq, datenum( nld(:,1) ).',datenum( nld(:,1) )) ;
[r,c] = find( corresp ) ;
And I get the following warning and error message
% Warning: Variable names were modified to make them valid MATLAB identifiers.
> In makeValidName at 25
In @table\private\setVarNames at 48
In table.readXLSFile at 113
In table.readFromFile at 35
In readtable at 118
In readdata at 2
Undefined function 'datetime' for input arguments of type 'cell'.
Error in readdata (line 4)
nld.Date = datetime(nld.Date,'InputFormat','MM/dd/yyyy')
Here is some sample of the imported variable nld
Date x10_Year
____________ ________
'24/06/2015' 1.08
'23/06/2015' 1.1
'22/06/2015' 1.11
'19/06/2015' 1.01
'18/06/2015' 1.04
'17/06/2015' 1.08
'16/06/2015' 1.11
'15/06/2015' 1.09
'12/06/2015' 1.09
'11/06/2015' 1.09
Could you identify what is the problem here? Thanks for your help.
Cheers,
Xueqi

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

采纳的回答

Walter Roberson
Walter Roberson 2015-6-27
nlddate = datenum( nld{:,1} );
corresp = bsxfun( @eq, nlddate.', nlddate ) ;
  2 个评论
xueqi
xueqi 2015-6-28
Thank you! It works! It seems that we need {} for tables!
Peter Perkins
Peter Perkins 2015-7-6
xueqi, a couple things:
  • You do not need {} for tables, you need {} for cell arrays of strings, which is what you have imported those datetimes in your file as. You will probably be happier specifying a %D format to readtable to read the strings in as datetimes, not as strings.
  • The error you are getting
Undefined function 'datetime' for input arguments of type 'cell'.
indicates that there is something you have not told us.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by