Convert Julian Date to Calendar Days.

Question

Edgar 2023-5-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1956709-convert-julian-date-to-calendar-days

回答： Cris LaPierre 2023-5-2

Book1.xlsx

I'm trying to Convert the Julian-Time header to include the Year header and output the format mm/dd/yyyy. i.e. 12/31/2022 & 01/01/2023.

The complete data for Book1.xlsx contains multiple years.

Thank you!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2023-5-2

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1956709-convert-julian-date-to-calendar-days#answer_1227779

在 MATLAB Online 中打开

Book1.xlsx

Perhaps a bit convoluted, but this appears to work. I haven't compared it extensively to the orginal data. Note that the display format only modifies how the data appears. The time is still there.

data = readtable('Book1.xlsx',"TextType","string");
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.
% your Julian_dates are surrounded by quotes. Remove them
data.Julian_Time = erase(data.Julian_Time,"'");
% use datetime to convert the combined date string to a datetime.
% DDD indicates day-of-year
data.Julian_Time = datetime(data.Year+"-"+data.Julian_Time,'InputFormat','uuuu-DDD-HH:mm:ss.SSS');
data.Julian_Time.Format = 'MM/dd/yyyy'
data = 185×4 table
YearJulian_TimeData1Data2___________________________

    2022    12/31/2022     36.425    21.998
    2022    12/31/2022     36.725    21.998
    2022    12/31/2022     36.425    21.998
    2022    12/31/2022     36.425    21.998
    2022    12/31/2022     36.725    21.998
    2022    12/31/2022     36.725    21.998
    2022    12/31/2022     36.425    21.998
    2022    12/31/2022     36.425    21.998
    2022    12/31/2022     36.425    21.998
    2022    12/31/2022     36.725    21.998
    2022    12/31/2022     36.725    21.998
    2022    12/31/2022     36.425    21.998
    2022    12/31/2022     36.425    21.998
    2022    12/31/2022     36.725    21.998
    2022    12/31/2022     36.425    21.998
    2022    12/31/2022     36.425    21.998