MATCHING EXCEL FILES USING MATLAB

4 次查看（过去 30 天）

Saptorshee Chakraborty 2021-3-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/788574-matching-excel-files-using-matlab

回答： Cris LaPierre 2021-12-24

Screenshot 2021-03-31 at 3.46.22 AM.png

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.