merge date time

1 次查看（过去 30 天）
Tiina
Tiina 2012-2-3
How can I merge the two columns together (into one) and generate a date time number for data like
20101229 154907
20101229 154908
20101229 154908
20101229 154909
20101229 154909
20101230 93001
20101230 93001
20101230 93004
and a result like
2010229154907 for row 1
2010229154907 for row 2 and so on
dates and times are doubles
thanks

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

回答（3 个）

Walter Roberson
Walter Roberson 2012-2-3
Do not accumarray() using these numbers as the subscripts. Instead,
Mu = unique(mergedtimes);
[tf, Muidx] = ismember(mergedtimes, Mu);
Then uses MuIdx(:) as the subscript for accumarray() purposes. Afterwards, you can map back row K of your accumarray results to time value Mu(K)
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2012-2-4
mod(mergedtime, 1000000) to get the time data,
fix(mergedtime ./ 1000000) to get the data data.
Tiina
Tiina 2012-2-4
yea awesome

请先登录，再进行评论。

Walter Roberson
Walter Roberson 2012-2-3
mergedtimes = data(:,1) * 1000000 + data(:,2);
James Tursa
James Tursa 2012-2-3
If X is your original M x 2 data:
X(:,1)*1000000 + X(:,2)
  1 个评论
Tiina
Tiina 2012-2-3
I tried before posting a q and bec I am using accumarray at one point in the code am running out of memory. When I did not merge the columns (that is accumarray by either columns) i didn not run out of memory so i though that merging by multiplying by a number would be related to the issue ..
is there any tip for this case?

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by