How to assing incrementing numbers to identical values in a column?

Question

A. Goeh 2016-8-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300497-how-to-assing-incrementing-numbers-to-identical-values-in-a-column

编辑： Andrei Bobrov 2016-8-22

Hello to all,

my ultimate goal of this question is to find a solution for the following problem: I am searching for the index of the first and last day of a month of one year specifically. To specify my question here a design of my data :

Column 1(Year) Column 2(Month) Column 3(Data)

1990 1 .098

1990 1 .99

1990 1 .34

1990 2 .56

1990 2 .44

In this example my answer would be IndexBeginning = 1 and IndexEnding= 3 for month 1 of the year 1990 and IndexBeginning = 4 and IndexEnding= 5 for month 2 of the year 1990.

To get specific values for a month and the respective years i have already merged the two first columns. January 1990, e.g., now has the designated number 19901 and February 1995 the number 19952. Now I´m trying to index those merged numbers from 1 to 293 ( number of month of my sample) in correct order so i can easily search for every month.

I´m very grateful for any and every idea!

with Kind Regards,

A Goeh

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

请先登录，再进行评论。

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

Answer 1

Azzi Abdelmalek 2016-8-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300497-how-to-assing-incrementing-numbers-to-identical-values-in-a-column#answer_232469

编辑：Azzi Abdelmalek 2016-8-22

在 MATLAB Online 中打开

M=[1990 1 .098;1990 1 .99;1990 1 .34;1990 2 .56;1990 2 .44]
[ii,jj,kk]=unique(M(:,1:2),'rows','stable')
out=[ii cell2mat(accumarray(kk,(1:numel(kk))',[],@(x) {[x(1) x(end)]}))]

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

A. Goeh 2016-8-22

Thank you very much!! It works perfectly and I wouldn´t have thought of such an elegant way of solving this problem.

请先登录，再进行评论。

Answer 2

Andrei Bobrov 2016-8-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300497-how-to-assing-incrementing-numbers-to-identical-values-in-a-column#answer_232477

编辑：Andrei Bobrov 2016-8-22

在 MATLAB Online 中打开

M = [1990 1 .098;1990 1 .99;1990 1 .34;1990 2 .56;1990 2 .44];
[ii,jj] = unique(M(:,1:2),'rows','first');
[~,kk]  = unique(M(:,1:2),'rows','last');
out = [ii,jj,kk];