Hello,

I have a data as follow:
ID    Visit
xa1
xa2
yb1
yc23
yb33
 
I want to look at frequency of visit for ID and create a new column as response . 
For example my response would be 2 for x and 3 for y.
I think I need to write a loop, but I don't know how.
I really appreciate your help.
Thanks a lot.
Best,Farnoosh Sheikhi
	[[alternative HTML version deleted]]

