How to find which columns are different between two tables

13 次查看（过去 30 天）

Curious Mind 2018-8-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/414527-how-to-find-which-columns-are-different-between-two-tables

评论： Dankur Mcgoo 2018-8-21

Hello:

I have 2 datasets (Table A and Table B). Table A has 1200 columns while that of B has 1205 columns. They all have the same number of rows. A and B are supposed to be the same but for some reason when I save A, 5 additional columns are added hence I get B (1205 columns instead of 1200).

I wanna find out what those 5 additional columns are. Is there a code that can let me compare A and B and tell me what those additional 5 columns in Table B are?

Thank you and I look forward to hearing from you soon.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Curious Mind 2018-8-12

Unfortunately I don’t have the files with me now. I’m saving Table A as a .dat file. I’m using 2017a version. It works fine just happened today. Every time I save data A 5 additional columns of data are added and I wanna know what those 5 columns are.

Walter Roberson 2018-8-12

.dat is not a standard file type. How are you doing the saving?

请先登录，再进行评论。

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

采纳的回答

Dankur Mcgoo 2018-8-12

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/414527-how-to-find-which-columns-are-different-between-two-tables#answer_332453

在 MATLAB Online 中打开

A = rand(3,3); 
B = [A, rand(3,1)]; % Generating random tables
idx = ~ismember(B,A);
LookSee = B(idx);

LookSee should have the columns you want...

2 个评论
显示无隐藏无

Curious Mind 2018-8-12

So since I have TableA and TableB would the code be like A = TableA; B = [A, TableB]; idx = ~ismember(B,A); LookSee = B(idx); ?

Dankur Mcgoo 2018-8-21

Yup!

请先登录，再进行评论。

类别

MATLAB Language Fundamentals Data Types Tables

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

Community Treasure Hunt

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

Start Hunting!

Translated by