Re: [R] concatenate 2 column vectors
Sorry I forgot the subject in my previous post Here is an example of data : province and district code of 4 locations datatry=matrix(c(8,12,3,3,1,1,16,1),4,2) colnames(datatry)-c(PROCODE,DISCODE) DISCODE is not unique for each location (there is a distrcit nb 1 in each province) I want to create a third column (DIS) which would contain a unique district code for each location that would be the appended values of the province code and the district code, and that would be a numeric value (not a character) here is my try (thanks to Henrique Dallazuanna!) DIS=rep(0,nrow(datatry)) datatry=cbind(datatry,DIS) datatry2=transform(datatry,DIS=paste(datatry[,1],datatry[,2])); However it creates a string, and the 2 codes are separated by an empty space, which I didn't manage to supress using different values for arguments sep and collapse. i'll try to see other options to concatenate 2 numeric values into a third one. Thanks --- En date de : Jeu 21.1.10, Henrique Dallazuanna www...@gmail.com a écrit : De: Henrique Dallazuanna www...@gmail.com Objet: Re: [R] (no subject) À: teurlai magali teurlai...@yahoo.fr Cc: r-help@r-project.org Date: Jeudi 21 Janvier 2010, 3h41 transform(DF, District_Unique = paste(Province, District, collapse = '')) On Thu, Jan 21, 2010 at 12:34 AM, teurlai magali teurlai...@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@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 [[alternative HTML version deleted]] __ 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.
Re: [R] concatenate 2 column vectors
Hi Magali, I confess that I still not figured out what you want, but try this: datatry2=transform(datatry,DIS=as.numeric(as.character(paste(datatry[,1],datatry[,2],sep= bests milton On Wed, Jan 20, 2010 at 11:14 PM, teurlai magali teurlai...@yahoo.frwrote: Sorry I forgot the subject in my previous post Here is an example of data : province and district code of 4 locations datatry=matrix(c(8,12,3,3,1,1,16,1),4,2) colnames(datatry)-c(PROCODE,DISCODE) DISCODE is not unique for each location (there is a distrcit nb 1 in each province) I want to create a third column (DIS) which would contain a unique district code for each location that would be the appended values of the province code and the district code, and that would be a numeric value (not a character) here is my try (thanks to Henrique Dallazuanna!) DIS=rep(0,nrow(datatry)) datatry=cbind(datatry,DIS) datatry2=transform(datatry,DIS=paste(datatry[,1],datatry[,2])); However it creates a string, and the 2 codes are separated by an empty space, which I didn't manage to supress using different values for arguments sep and collapse. i'll try to see other options to concatenate 2 numeric values into a third one. Thanks --- En date de : Jeu 21.1.10, Henrique Dallazuanna www...@gmail.com a écrit : De: Henrique Dallazuanna www...@gmail.com Objet: Re: [R] (no subject) À: teurlai magali teurlai...@yahoo.fr Cc: r-help@r-project.org Date: Jeudi 21 Janvier 2010, 3h41 transform(DF, District_Unique = paste(Province, District, collapse = '')) On Thu, Jan 21, 2010 at 12:34 AM, teurlai magali teurlai...@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 111 1 212 13 2132 I can create a loop, but it becomes complicated with numerous data Thanks for your help [[alternative HTML version deleted]] __ 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.htmlhttp://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 [[alternative HTML version deleted]] __ 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.htmlhttp://www.r-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]] __ 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.
Re: [R] concatenate 2 column vectors
On Jan 20, 2010, at 11:14 PM, teurlai magali wrote: Sorry I forgot the subject in my previous post Here is an example of data : province and district code of 4 locations datatry=matrix(c(8,12,3,3,1,1,16,1),4,2) colnames(datatry)-c(PROCODE,DISCODE) cbind( datatry, paste(datatry[, PROCODE], datatry[, DISCODE], sep=.) ) PROCODE DISCODE [1,] 8 1 8.1 [2,] 121 12.1 [3,] 3 163.16 [4,] 3 1 3.1 DISCODE is not unique for each location (there is a distrcit nb 1 in each province) I want to create a third column (DIS) which would contain a unique district code for each location that would be the appended values of the province code and the district code, and that would be a numeric value (not a character) here is my try (thanks to Henrique Dallazuanna!) DIS=rep(0,nrow(datatry)) datatry=cbind(datatry,DIS) datatry2=transform(datatry,DIS=paste(datatry[,1],datatry[,2])); However it creates a string, and the 2 codes are separated by an empty space, which I didn't manage to supress using different values for arguments sep and collapse. i'll try to see other options to concatenate 2 numeric values into a third one. Thanks --- En date de : Jeu 21.1.10, Henrique Dallazuanna www...@gmail.com a écrit : De: Henrique Dallazuanna www...@gmail.com Objet: Re: [R] (no subject) À: teurlai magali teurlai...@yahoo.fr Cc: r-help@r-project.org Date: Jeudi 21 Janvier 2010, 3h41 transform(DF, District_Unique = paste(Province, District, collapse = '')) On Thu, Jan 21, 2010 at 12:34 AM, teurlai magali teurlai...@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 111 1 212 13 2132 I can create a loop, but it becomes complicated with numerous data Thanks for your help [[alternative HTML version deleted]] __ 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. -- Henrique Dallazuanna Curitiba-Paraná-Brasil 25° 25' 40 S 49° 16' 22 O [[alternative HTML version deleted]] __ 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. David Winsemius, MD Heritage Laboratories West Hartford, CT __ 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.
Re: [R] concatenate 2 column vectors
datatry2=transform(datatry,DIS=as.numeric(paste(datatry[,1],datatry[,2],sep=))) It works like this !! You understood perfectly well what I needed ;-) Thanks to all that answered Magali --- En date de : Jeu 21.1.10, milton ruser milton.ru...@gmail.com a écrit : De: milton ruser milton.ru...@gmail.com Objet: Re: [R] concatenate 2 column vectors À: teurlai magali teurlai...@yahoo.fr Cc: Henrique Dallazuanna www...@gmail.com, r-help@r-project.org Date: Jeudi 21 Janvier 2010, 5h23 Hi Magali, I confess that I still not figured out what you want, but try this: datatry2=transform(datatry,DIS=as.numeric(as.character(paste(datatry[,1],datatry[,2],sep= bests milton On Wed, Jan 20, 2010 at 11:14 PM, teurlai magali teurlai...@yahoo.fr wrote: Sorry I forgot the subject in my previous post Here is an example of data : province and district code of 4 locations datatry=matrix(c(8,12,3,3,1,1,16,1),4,2) colnames(datatry)-c(PROCODE,DISCODE) DISCODE is not unique for each location (there is a distrcit nb 1 in each province) I want to create a third column (DIS) which would contain a unique district code for each location that would be the appended values of the province code and the district code, and that would be a numeric value (not a character) here is my try (thanks to Henrique Dallazuanna!) DIS=rep(0,nrow(datatry)) datatry=cbind(datatry,DIS) datatry2=transform(datatry,DIS=paste(datatry[,1],datatry[,2])); However it creates a string, and the 2 codes are separated by an empty space, which I didn't manage to supress using different values for arguments sep and collapse. i'll try to see other options to concatenate 2 numeric values into a third one. Thanks --- En date de : Jeu 21.1.10, Henrique Dallazuanna www...@gmail.com a écrit : De: Henrique Dallazuanna www...@gmail.com Objet: Re: [R] (no subject) À: teurlai magali teurlai...@yahoo.fr Cc: r-help@r-project.org Date: Jeudi 21 Janvier 2010, 3h41 transform(DF, District_Unique = paste(Province, District, collapse = '')) On Thu, Jan 21, 2010 at 12:34 AM, teurlai magali teurlai...@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@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 [[alternative HTML version deleted]] __ 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. [[alternative HTML version deleted]] __ 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.
