フィルターのクリア

Merge multiple columns based on match rows using loop

1 回表示 (過去 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 ExchangeData Import from MATLAB についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by