How do i create a table with increments of occurrences of a value based on another column?
8 views (last 30 days)
Show older comments
I have a vector as: [1,2,3,4,5,1,3,4,6,5,1,3]
How do i create another vector as: [1,1,1,1,1,2,2,2,1,2,3,3]
Since 1 is repeating 3 times so i replaced the 1st occurance of 1 by 1, second occurence by 2 and third occurence by 3. Similarly, i did for others.
0 Comments
Answers (1)
David Hill
on 8 Jun 2021
x= [1,2,3,4,5,1,3,4,6,5,1,3];
y=unique(x);
z=ones(size(x));
for k=y
a=find(x==k);
z(a)=1:length(a);
end
2 Comments
David Hill
on 8 Jun 2021
k just goes through the y array ([1 2 3 4 5 6]), taking on each value one at a time.
See Also
Categories
Find more on NaNs in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!