delete duplicated rows, (with saving some data)

Question

Amr Hashem 2015-5-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/217051-delete-duplicated-rows-with-saving-some-data

评论： Amr Hashem 2015-5-16

i have this table (size:8*2): ( 1st column has numbers some of them is duplicated)

i want to delete the duplicated row but save the (2th column & or 3rd) in the origin number to form a table (size:5*3) like this:

434846 x y
434850 f
434854 s
434859 A B C
434862 N

how i can do this?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2015-5-16

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/217051-delete-duplicated-rows-with-saving-some-data#answer_179320

编辑：Star Strider 2015-5-16

在 MATLAB Online 中打开

This works:

A = {434846 'x'
434846 'y'
434850 'f'
434854 's'
434859 'A'
434859 'B'
434859 'C'
434862 'N'};
% 
A1 = cell2mat(A(:,1));
[Au,ia,ic] = unique(A1);
for k1 = 1:size(Au,1)
    A2{k1,:} = {Au(k1) A(k1==ic,2)};
end

EDIT — Print loop for ‘A2’:

for k1 = 1:size(A2,1)
    fprintf(1, ['\n%d\t' repmat('%s  ',1, length(A2{k1}{2}))],  A2{k1}{1}, char(A2{k1}{2}))
end
fprintf(1, '\n')

produces:

434846  xy  
434850  f  
434854  s  
434859  ABC  
434862  N

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

Amr Hashem 2015-5-16

在 MATLAB Online 中打开

thank you

it works

but it put the duplicated text over eachother

it gives me:

 434846  CCOOMMPPLLAAIINNAANNTT  AALLLLEEGGEEDD  TTHHAATT  
434850  COMPLAINANT ALLEGED THAT DURING A ROUTINE SHIFT CHECK BY A 
434854  COMPLAINANT ALLEGED THAT DURING A ROUTINE SHIFT CHECK BY A   
434859  CVAOECMRCPIELFSAISIE NDPA ONRRTET P AOBLRRLTOGEKEDED N M.TA  .   
434862  COMPLAINANT ALLEGED THAT