Merge multiple columns based on match rows using loop
1 回表示 (過去 30 日間)
古いコメントを表示
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
0 件のコメント
回答 (1 件)
参考
カテゴリ
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!