フィルターのクリア

How to compare two different excel sheets specific columns for like values

23 ビュー (過去 30 日間)
Tyler Ginet
Tyler Ginet 2022 年 1 月 21 日
コメント済み: Tyler Ginet 2022 年 1 月 24 日
I am trying to compare two excel files, specifically a column in each. The cells contain numbers and letters and arent in order. I am trying to update a condensed list to ensure that it has the master's values. It has been a few years since ive used MATLAB. I tried using the setdiff function to compare arrays from each with no luck. TIA!
  7 件のコメント
Voss
Voss 2022 年 1 月 21 日
I thought you want to find out which values in the full list aren't in the condensed list:
C = A(~ismember(A,B)); % Full list elements not in Condensed list
rtather than which values in the condensed list aren't in the full list:
D = B(~ismember(B,A)); % Condensed list elements not in Full list
Tyler Ginet
Tyler Ginet 2022 年 1 月 24 日
I tried both C and D. Unfortunately that didnt work. Thank you though!

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

回答 (1 件)

Ive J
Ive J 2022 年 1 月 22 日
xlsread is deprecated, avoid it.
fullTab = readtable('File1.xlsx');
denseTab = readtable('File2.xlsx');
[idxFull, idxDense] = ismember(fullTab.(13), denseTab.(3));
idxDense(idxDense < 1) = [];
fullCol13Unique = A.(13)(~idxFull);

カテゴリ

Help Center および File ExchangeData Import from MATLAB についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by