Merge multiple columns based on match rows using loop

I have two excel files:

excel file 1 which is shown on image 1, contains standard time series data.

excel file 2 which is shown on image 2, contains time series recording of different geographical location and the wind speed values of corresponding geographical location.

The aim of project is merged wind speed values of excel file 2 with standard time series of excel file 1, if the time series recording rows at excel file 2 match with the standard time series of excel file 1. The expected result is shown as image 3.

The excel files are attached.

I used to try to use python to solve the problem, but it is really difficult in programming for such mutiple columns case. It seems it would be easier to handel by Matlab.

Could our experts help me with that?

image 1

image 2

image 3

Answer 1

[dpb]

There's <an example> of precisely that operation with synchronize and timetables