How I find four or five colunms with distict rows from a table

Question

Umme ruman Wattoo 2023-1-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1897010-how-i-find-four-or-five-colunms-with-distict-rows-from-a-table

回答： David Hill 2023-1-19

I have a table with 46 columns and 115 rows and I have to find 3 or 4 or 5 such columns that all have distinct rows.In that 4 columns there should not be repeatation in entire 115 rows

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

Mathieu NOE 2023-1-19

you simply have to test each column and see if you have 115 unique values

read doc / help of unique

请先登录，再进行评论。

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

Answer 1

David Hill 2023-1-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1897010-how-i-find-four-or-five-colunms-with-distict-rows-from-a-table#answer_1152045

在 MATLAB Online 中打开

First convert your table into a matrix using table2array()

A=randi(100,115,64);
k=nchoosek(1:64,5);%all combinations of 5 columns (change for 3 and 4)
y=[];
for m=1:size(k,1)
   t=A(:,k(m,:));
   t=unique(t,'rows');
   if size(t,1)==115
      y=[y,m];%all rows of k that meet the condition
   end
end
k(y,:)%all combinations of 5 columns where all 115 rows are unique