Customized datetime format within table

Question

Vic 2023-12-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2055229-customized-datetime-format-within-table

回答： Peter Perkins 2023-12-4

Hi all,

I am trying to compare 2 tables (for both 1st column is datetime, others are numbers). I am trying to find the common timeperiod between those 2 tables. Unfortunately, days are not the same. My original idea is to convert dates into string and look for matching strings between both tables.

Question:

I am a beginner at Matlab, is there a better way to do it? If not, is there an elegant way to get rid of the 2 loops?

Here is the script for the transformation shown in the workspace

------------------------------------------------------------

A1 = readtable(file_name,'VariableNamingRule','preserve'); clc;
B1 = readtable('Independant variables.xlsx');
for i = 1:height(A1)
    A2{i,1} = extractBetween(datestr(A1{i,1}),4,11);
end
for j = 1:height(B1)
    B2{j,1} = extractBetween(datestr(B1{j,1}),4,11);
end

------------------------------------------------------------

Thanks and best regards,

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

Walter Roberson 2023-12-2

See also overlapsrange -- especially with the second output

Vic 2023-12-3

Thanks you both for your inputs. It helped me finding a solution to my issue.

Here is the working solution returning an array of boolean values.

--------------------------------------------------------------------

A1 = readtable(file_name,'VariableNamingRule','preserve');

B1 = readtable('Variables.xlsx');

Timeframe1 = table2timetable(A1);

Timeframe2 = timerange(B1.observation_date(1),B1.observation_date(end),'months');

[~,Overlap]= overlapsrange(Timeframe1,Timeframe2);

请先登录，再进行评论。

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

Answer 1

Vic 2023-12-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2055229-customized-datetime-format-within-table#answer_1364649

Thanks you both for your inputs. It helped me finding a solution to my issue.

Here is the working solution returning an array of boolean values.

--------------------------------------------------------------------

A1 = readtable(file_name,'VariableNamingRule','preserve');

B1 = readtable('Variables.xlsx');

Timeframe1 = table2timetable(A1);

Timeframe2 = timerange(B1.observation_date(1),B1.observation_date(end),'months');

[~,Overlap]= overlapsrange(Timeframe1,Timeframe2);

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

Dyuman Joshi 2023-12-3

You can also use readtimetable directly. (available for R2019a and afterwards)

请先登录，再进行评论。

Answer 2

Peter Perkins 2023-12-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2055229-customized-datetime-format-within-table#answer_1365344

在 MATLAB Online 中打开

Vic, I think you want synchronize.

tt1 = timetable([1;2;3;4;5],RowTimes=datetime(2023,1:5,1))
tt1 = 5×1 timetable
       Time        Var1
    ___________    ____

    01-Jan-2023     1  
    01-Feb-2023     2  
    01-Mar-2023     3  
    01-Apr-2023     4  
    01-May-2023     5  
tt2 = timetable([6;7;8;9;10],RowTimes=datetime(2023,1:5,[31 28 31 30 31]))
tt2 = 5×1 timetable
       Time        Var1
    ___________    ____

    31-Jan-2023      6 
    28-Feb-2023      7 
    31-Mar-2023      8 
    30-Apr-2023      9 
    31-May-2023     10 
tt3 = synchronize(tt1,tt2,"monthly","firstvalue");
tt3.Time.Format = "MMM-uuuu"
tt3 = 5×2 timetable
      Time      Var1_tt1    Var1_tt2
    ________    ________    ________

    Jan-2023       1            6   
    Feb-2023       2            7   
    Mar-2023       3            8   
    Apr-2023       4            9   
    May-2023       5           10   