Help Optimize slow Datestr() function performance

2 次查看（过去 30 天）
Brian
Brian 2014-1-17
评论： Brian 2014-1-20
I have imported a large text file with textual dates in the format m/d/yyyy. The end result that I need is a numeric date (for export to another system) in the format yyyymmdd. Since my text file is rather large (850,000 rows) my current method for conversion is really slow. It's taking about 50 seconds for the single line of code to run and is about 75% of my code's total run time. Since I have to run this code iteratively at times I'm interested in any suggestions to optimize how I'm using datestr, or an alternative.
Here's my code
tic
MyDates = str2num(datestr(MyData{1,2},'yyyymmdd'));
toc
yields - Elapsed time is 49.348078 seconds.
  2 个评论
Brian
Brian 2014-1-17
{'12/31/1989';'1/31/1990';'2/28/1990';'3/31/1990'};
850,000 rows of a cell containing date text. It would be a little easier if the month came in the format 'mm', but it does not. For months 1-9, there is just a single number.

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2014-1-17
t = datevec(MyData{1,2});
MyDates = t(:,1) * 10000 + t(:,2) * 100 + t(:,3);
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2014-1-17
Out of interest, how long does it take now? Comparing to the 50 seconds.
Brian
Brian 2014-1-20
Ran it three times and now takes between 5.5 and 6.5 seconds. Again, thanks a lot. That's a dramatic improvement.

请先登录，再进行评论。

更多回答（0 个）

类别

在 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