Combine two tables based on date time

Question

Dion Theunissen 2021-8-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/891562-combine-two-tables-based-on-date-time

评论： Peter Perkins 2021-8-5

I have a table A with a datetime (Year, month day and time) and a table B with a datetime(year month day)

Now I have to combine those two tables with each other based on the date. I have to check what date will match from table A to table B and the that index of table B.

For now I have this script, but it doesn't work

    check = dir('*.xls');
    
    weatherYear = readtable("/Users/diontheunissen/Documents/Smart_Driver/RawData/weatherYear.xlsx", opts, "UseExcel", false);
    Date = datetime(weatherYear.Aug2020);
     
    name = fullfile(check(1).folder, check(1).name);
    Ritten = readtable(name, opts, "UseExcel", false);
    
    Datum = datetime(Ritten.Starttijd);
    Datum.Format = 'dd-MMM-yyy';
    Ritten.Starttijd = Datum;
    t1 = datetime(Datum,'InputFormat','yyyy-MM-dd');
    t2 = datetime(Date,'Format','yyyy-MM-dd');
    [logical_Index ,index] = ismember(t1,t2);
    

A =

B=

Anyone who can help me?

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

请先登录，再进行评论。

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

Answer 1

Scott MacKenzie 2021-8-3

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/891562-combine-two-tables-based-on-date-time#answer_759822

TT1 = table2timetable(A);
TT2 = table2timetable(B):
TT3 = synchronize(TT1, TT2);

2 个评论
显示无隐藏无

Dion Theunissen 2021-8-3

Check my update, maybe it will be a bit more clear

Peter Perkins 2021-8-5

Scott's answer is the right way to do this, although you may want to be more xplicit and specify the target time vector and the method. But I think the defaults do what you want.

请先登录，再进行评论。