Definition of Time

Question

Liviu 2012-3-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/31499-definition-of-time

I have a file data with:

Column1: Year (2011)
Column2: Month (10)
Column3: Day (22)
Column4: Hour (10)
Column5: Minute (35)
Column6: Second (30)

These are "86400x1 double" so a lot of data.

I want to have a variable or another cell with TIME like:

YYYY.MM.DD HH.MM.SS (2011.10.22 10.35.30)

How could I concatenate or merge all elements?

I need to use it after that to find the DATE and TIME (X) in the database and to delete until the next (Y) value TIME. At the end I have to plot all and have an average of temperatures (The data has also some columns with temperatures)

Thank you

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

Liviu 2012-3-7

Input format is 6 columns and 86400 rows. It means that first column is YEAR and so on. The output format that I like is to have all these columns in one to be able to plot Axis X like complete data, not only YEAR or DAY, etc.

Do you understand now? Thanks

Liviu 2012-3-7

YEAR MONTH DAY HOUR MINUTE SEC Temp1 Temp2

2011 11 01 00 00 00 30 40

2011 12 02 10 30 50 50 60

What I like is to be able to merge or to define the full time in order to plot it.

X Axis TIME

Y Axis Temp1

Y2 Axis Temp 2

请先登录，再进行评论。

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

Answer 1

Dr. Seis 2012-3-7

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/31499-definition-of-time#answer_40006

在 MATLAB Online 中打开

DateNumber = datenum([Y, M, D, H, MN, S])

So...

X = datenum(data(:,1:6))-min(datenum(data(:,1:6))); % Normalized time
Y1 = data(:,7);
Y2 = data(:,8);

X is time in terms of fraction of a day - to get X in terms of seconds, multiply by 24*60*60

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

Liviu 2012-3-7

Thanks.

请先登录，再进行评论。

Answer 2

Liviu 2012-3-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/31499-definition-of-time#answer_40090

clear all

DELIMITER = ' '; HEADERLINES = 43;

newData = importdata('DATA_20111022.TSFB', DELIMITER, HEADERLINES); vars = fieldnames(newData);

for i = 1:length(vars) assignin('base', vars{i}, newData.(vars{i})); end

clear vars DELIMITER HEADERLINES newData i textdata

X=datenum(data(:,1:6)); plot(X,data(:,8))

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

Dr. Seis 2012-3-8

At what point do you assign the data to "data"?

Liviu 2012-3-9

Yes. This is wrong to clear the variables.

I assign the data to can save after.

How to find and copy from data1.dat to data3.dat The searching interval is found in data2.mat

I need to find in a database the time and to copy some of the rows in another files. INPUT1: data1.mat Col1=Time0 (datenum format "01-Mar-2000 15:45:17") Col2=Temp1 Col3=Temp2 INPUT2: data2.mat Col1=Time1 (datenum format "01-Mar-2000 15:45:17") Col2=Time2 (datenum format "01-Mar-2000 15:45:17")

INPUT3: data3.mat like INPUT1

Questions: 1. I want to find: the "Time1" from the "data2.mat" to fit with the "Time0" in the "data1.mat" 2. And find "Time2: from the "data2.mat" to fit with the "Time0" in the "data1.mat" 3. Copy from Time1 to Time2 from data1.mat in the data3.mat all the row.

2 comments

请先登录，再进行评论。