[R] copy the columns based on the code

[MSousa]

Thanks for the reply.

    I am using the function you gave me.

complete.travel<-merge(travel, city, by.x = "Source", by.y = "cod", all =
TRUE)
complete.travel<-merge(travel, city, by.x = "Destine", by.y = "cod", all =
TRUE
                       

The problem is that it gives the result that I want
   The idea is based on the column of source and intended Identify the
cities and put a new data structure

The idea is something like this.     
pos Source     city       Destine  city_destine
1      1       Barcelona   2       Madrid
1      1       Barcelona   3       Lisbon
2      3       Lisbon      4       Milan
3      2       Madrid      4       Milan




--
View this message in context: http://r.789695.n4.nabble.com/copy-the-columns-based-on-the-code-tp4505253p4505939.html
Sent from the R help mailing list archive at Nabble.com.