MATCHING EXCEL FILES USING MATLAB

1 次查看（过去 30 天）
Saptorshee Chakraborty
回答： Cris LaPierre 2021-12-24
Hello,
I would like to match two seperate sheets containing EU-ETS installations (ID) location and emission details (ED) of such installations. Both the ID file and ED file contains unique identification code PERMIT_ID. The problem is there are more than 15,000 entries for ID and more than 12,000 entries for ED, I want to match both the files and find the locations for installations in the ED file, I know the only way is to use by PERMIT_ID, but I cannot figure out the command. . I have checked in excel both the files have more than 10,000 common entries. I also do not want to discard the extra 2,000 in the ED file.
The columns look as the screenshot pasted below. I would really appreciate if you can suggest me a way.
  4 个评论
显示 2更早的评论
darova
darova 2021-3-31
You can use interp1 to make data the same size

请先登录，再进行评论。

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

回答（1 个）

Cris LaPierre
Cris LaPierre 2021-12-24
Load both files using readtable, then merge the tables using join.
If you are new to joining tables, I recommend using the Join Tables live task in the live editor (see here)

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by