different excel file comparisons

Hello, I have two excel files,
First excel file as shown below
and second excel file as shown below.
I want to compare these excel files values but ı have a problem. As you seen in the first column the order of the names are not same. How can I compare these two excel file among the same names.I will print the results on the adjacent column after the comparison.

回答 (1 件)

KSSV
KSSV 2021 年 4 月 19 日

1 投票

T1 = readtable(file1) ;
T2 = readtable(file2) ;
idx = ismember(T1.names, T2.names)

1 件のコメント

Lütfü Emre Efe
Lütfü Emre Efe 2021 年 4 月 19 日
Thank you. I also want to compare their values by sorting the names.

サインインしてコメントする。

カテゴリ

ヘルプ センター および File ExchangeData Import from MATLAB についてさらに検索

製品

質問済み:

2021 年 4 月 19 日

コメント済み:

2021 年 4 月 19 日

Community Treasure Hunt

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

Start Hunting!

Translated by