Merge multiple columns based on match rows using loop

3 次查看（过去 30 天）
Kaiyuan
Kaiyuan 2024-9-3
回答： dpb 2024-9-3
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

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

回答（1 个）

dpb
dpb 2024-9-3
There's <an example> of precisely that operation with synchronize and timetables

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by