Dear Community

I have a large dataframe x as follows with common ids but different names:

> x <- data.frame(ID = c(1,1,2,2,2,3,3),
+ Name = c("B Branch A Firm ","A Firm","B Firm","B Firm","B Firm C Branch","C Firm","C Firm A Branch")
+ )
> x
  ID             Name
1  1 B Branch A Firm 
2  1           A Firm
3  2           B Firm
4  2           B Firm
5  2  B Firm C Branch
6  3           C Firm
7  3  C Firm A Branch

Q: How can I turn it into a dataframe with common id and common names, like this:

> y <- data.frame(ID = c(1,1,2,2,2,3,3),
+ Name = c("A Firm","A Firm","B Firm","B Firm","B Firm","C Firm","C Firm")
+ )
> y
  ID   Name
1  1 A Firm
2  1 A Firm
3  2 B Firm
4  2 B Firm
5  2 B Firm
6  3 C Firm
7  3 C Firm

Although I searched a lot, I am still not able to find answers to my question.  Please help.

Thanks in advance.

2012-03-09



Chen
	[[alternative HTML version deleted]]

