How can I use: DateString/datevac for a long year dataset? Dates from 01/01/1988 to 05/03/2005?

3 次查看（过去 30 天）

显示更早的评论

Ice lady 2016-7-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/297650-how-can-i-use-datestring-datevac-for-a-long-year-dataset-dates-from-01-01-1988-to-05-03-2005

编辑： Ice lady 2016-8-1

采纳的回答： Andrei Bobrov

在 MATLAB Online 中打开

How can I use: DateString = '01/01/1988'; formatIn = 'dd/mm/yyyy'; datevec(DateString,formatIn)

to convert a long data column Date = G(:,1); Dates are in dd/mm/yyyy: from 01/01/1988 to 05/03/2005 and I need to change them to yyyy mm dd to have them the same as other data I am using in a script?

It currently converts only 01/01/1988, to:

ans =

1988 1 1 0 0 0

I tried:

DateString = '01/01/1988:05/03/2005'; formatIn = 'dd/mm/yyyy'; datevec(DateString,formatIn)

But it still only did 01/01/1988

Data matrix is as follows: Full Date = G(:,1); Year = G(:,2); Temp data = G(:,3);

Then I just want to output new date to be: year (column 1), month(column 2), day(column 3) and temperature data (column 4)

Any help appreciated.

2 个评论
显示无隐藏无

Andrei Bobrov 2016-7-29

please attach your data 'G'

Ice lady 2016-7-29

FB_DSAT_1988to2005with year_USE.txt

Here is my data file

请先登录，再进行评论。

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

采纳的回答

Andrei Bobrov 2016-7-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/297650-how-can-i-use-datestring-datevac-for-a-long-year-dataset-dates-from-01-01-1988-to-05-03-2005#answer_230170

编辑：Andrei Bobrov 2016-7-29

在 MATLAB Online 中打开

bed variant (Now I do not have access to MATLAB and use the Octave):

f = fopen('FB_DSAT_1988to2005with year_USE.txt'); 
c = textscan(f,'%s','delimiter','\n'); 
fclose(f);
c = c{:}(~cellfun(@isempty,c{:}));
z = regexp(c,'(\-)?\d*(\.)?','match');
zz = cell2mat(cellfun(@(x)str2double([x(3:-1:1) [x{5:end}]]),z,'un',0));

mean daily:

[dly,~,ii] = unique(zz(:,1:3),'rows');
out = [dly, accumarray(ii,zz(:,end),[],@mean)];

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

Andrei Bobrov 2016-7-29

I am edited my answer

Ice lady 2016-7-29

Dear Andrei, Thanks very much. Appears to work a treat after adding some extra script to display and save to a writable file. Thanks once again. Wish I had asked for some assistance earlier.

请先登录，再进行评论。