yet another way: > city<-data.frame(city="Barcelona",cod=1) > city<-rbind(city,data.frame(city="Madrid",cod=2)) > city<-rbind(city,data.frame(city="Lisbon",cod=3)) > city<-rbind(city,data.frame(city="Milan",cod=4)) > city<-rbind(city,data.frame(city="London",cod=5)) > > travel<-data.frame(pos=1,Source=1,Destine=2) > travel<-rbind(travel,data.frame(pos=1,Source=1,Destine=3)) > travel<-rbind(travel,data.frame(pos=2,Source=3,Destine=4)) > travel<-rbind(travel,data.frame(pos=3,Source=2,Destine=4)) > travel<-rbind(travel,data.frame(pos=4,Source=1,Destine=3)) > > travel$city <- city$city[match(travel$Source, city$cod)] > travel$city_destine <- city$city[match(travel$Destine, city$cod)] > > travel pos Source Destine city city_destine 1 1 1 2 Barcelona Madrid 2 1 1 3 Barcelona Lisbon 3 2 3 4 Lisbon Milan 4 3 2 4 Madrid Milan 5 4 1 3 Barcelona Lisbon >
On Tue, Mar 27, 2012 at 12:15 PM, MSousa <ricardosousa2...@clix.pt> wrote: > > > Hello, > > this code, works perfectly > temp <- merge(travel, city, by.x="Source", by.y="cod") > result <- merge(temp, city, by.x="Destine", by.y="cod") > > The problem was the construction of the data frame, had a parenthesis in > city<-rbind(city,data.frame(city="Lisbon",cod=3))), > > I tried to delete the post, but i don't could. > As I have little experience in R, I still do some mistakes. > I use read.table to load the data frame, the way in the post, it was quickly > that i found to describe the problem. > The forum has been a great help for me. > > Thanks > > > > > > > > -- > View this message in context: > http://r.789695.n4.nabble.com/copy-the-columns-based-on-the-code-tp4505253p4509340.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. -- Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
