Getting unique values of an excel sheet relying on one column only.

1 次查看（过去 30 天）

ND 2016-9-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/301879-getting-unique-values-of-an-excel-sheet-relying-on-one-column-only

评论： ND 2016-9-4

Please, I have an excel file with many rows and five columns. I need to remove the duplicated data of all columns considering the uniqueness of the last column only.

For example:( x,y,z,p,f) are columns

x y z p f

1 2 3 4 5

1 3 5 6 4

2 3 5 7 4

3 4 1 5 4

the result should be

1 2 3 4 5

1 3 5 6 4

Many thanks for help.

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

请先登录，再进行评论。

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

采纳的回答

Andrei Bobrov 2016-9-4

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/301879-getting-unique-values-of-an-excel-sheet-relying-on-one-column-only#answer_233758

在 MATLAB Online 中打开

z = [1 2 3 4 5
1 3 5 6 4
2 3 5 7 4
3 4 1 5 4];
[~,b] = unique(z(:,end),'stable');
out = z(b,:);

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

ND 2016-9-4

Many thanks

请先登录，再进行评论。

类别

Computational Finance Spreadsheet Link Data Import from MATLAB

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by