Hi
is there a way in R to create a new column vector with the numbers of 2 others
columns simply appended?
Example : I have a column with provinces codes (1 to 19)
I have a second column with districts codes (1 to ##, depending on the province)
I want to create a third column with a code that would be unique for each
district:
Province District District_Unique
1 1 11
1 2 12
13 2 132
I can create a loop, but it becomes complicated with numerous data
Thanks for your help
[[alternative HTML version deleted]]
transform(DF, District_Unique = paste(Province, District, collapse = '')) On Thu, Jan 21, 2010 at 12:34 AM, teurlai magali <teurlaimag at yahoo.fr> wrote:> Hi > > is there a way in R to create a new column vector with the numbers of 2 others columns simply appended? > > Example : I have a column with provinces codes (1 to 19) > I have a second column with districts codes (1 to ##, depending on the province) > I want to create a third column with a code that would be unique for each district: > > Province? District?? District_Unique > 1???????????? 1??????????? 11 > 1???????????? 2??????????? 12 > 13?????????? 2??????????? 132 > > I can create a loop, but it becomes complicated with numerous data > > Thanks for your help > > > > > > ? ? ? ?[[alternative HTML version deleted]] > > > ______________________________________________ > R-help at 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. > >-- Henrique Dallazuanna Curitiba-Paran?-Brasil 25? 25' 40" S 49? 16' 22" O
On Jan 20, 2010, at 9:34 PM, teurlai magali wrote:> Hi > > is there a way in R to create a new column vector with the numbers > of 2 others columns simply appended? > > Example : I have a column with provinces codes (1 to 19) > I have a second column with districts codes (1 to ##, depending on > the province) > I want to create a third column with a code that would be unique for > each district: > > Province District District_Unique > 1 1 11 > 1 2 12 > 13 2 132 >Better to put in a separator. That way you can tell Prov=1, Distr=11 from Prov=11, Distr=1. Try: df$Distric_Unique <- with(df, paste(Province, District, sep=".") )> I can create a loop, but it becomes complicated with numerous data > > Thanks for your help > > > > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at 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.David Winsemius, MD Heritage Laboratories West Hartford, CT