different excel file comparisons

18 visualizzazioni (ultimi 30 giorni)
Lütfü Emre Efe
Lütfü Emre Efe il 19 Apr 2021
Commentato: Lütfü Emre Efe il 19 Apr 2021
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.

Risposte (1)

KSSV
KSSV il 19 Apr 2021
T1 = readtable(file1) ;
T2 = readtable(file2) ;
idx = ismember(T1.names, T2.names)
  1 Commento
Lütfü Emre Efe
Lütfü Emre Efe il 19 Apr 2021
Thank you. I also want to compare their values by sorting the names.

Accedi per commentare.

Categorie

Scopri di più su Data Import from MATLAB in Help Center e File Exchange

Prodotti

Community Treasure Hunt

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

Start Hunting!

Translated by