Dear all, I would like to know how can I concatenate 2 data.frames into a single one. Both data frames have the same number of columns and the same class type in each correspondent column. So what I want is to have a new data.frame where I have first the values from one data.frame and then the values from a second data.frame would came after in this new data.frame. Thanks in advance. Med venlig hilsen / Regards João Fadista Ph.d. studerende / Ph.d. student AARHUS UNIVERSITET / UNIVERSITY OF AARHUS Det Jordbrugsvidenskabelige Fakultet / Faculty of Agricultural Sciences Forskningscenter Foulum / Research Centre Foulum Genetik og Bioteknologi / Dept. of Genetics and Biotechnology Blichers Allé 20, P.O. BOX 50 DK-8830 Tjele Tel: +45 8999 1900 Direct: +45 8999 1900 Mobile: +45 E-mail: Joao.Fadista@agrsci.dk <mailto:Joao.Fadista@agrsci.dk> Web: www.agrsci.dk <http://www.agrsci.dk/> ________________________________ Tilmeld dig DJF's nyhedsbrev / Subscribe Faculty of Agricultural Sciences Newsletter <http://www.agrsci.dk/user/register?lan=dan-DK> . Denne email kan indeholde fortrolig information. Enhver brug eller offentliggørelse af denne email uden skriftlig tilladelse fra DJF er ikke tilladt. Hvis De ikke er den tiltænkte adressat, bedes De venligst straks underrette DJF samt slette emailen. This email may contain information that is confidential. Any use or publication of this email without written permission from Faculty of Agricultural Sciences is not allowed. If you are not the intended recipient, please notify Faculty of Agricultural Sciences immediately and delete this email. [[alternative HTML version deleted]]
On Fri, 2007-03-23 at 08:51 +0100, Jo?o Fadista wrote:> Dear all, > > I would like to know how can I concatenate 2 data.frames into a single > one. Both data frames have the same number of columns and the same > class type in each correspondent column. So what I want is to have a > new data.frame where I have first the values from one data.frame and > then the values from a second data.frame would came after in this new > data.frame. > > Thanks in advance.By "after", do you mean columns for dataframe1 then columns of dataframe2, or do you mean you want to append dataframe2 onto the bottom of dataframe1? The first is: dat1 <- data.frame(var1 = rnorm(10), var2 = rnorm(10), var3 = gl(2, 5, labels = c("red", "blue"))) dat2 <- data.frame(var4 = rnorm(10), var5 = rnorm(10), var6 = gl(2, 5, labels = c("red", "blue"))) combined <- data.frame(dat1, dat2) combined var1 var2 var3 var4 var5 var6 1 -1.61397560 -0.40296928 red 1.48380888 1.35501273 red 2 1.01901681 -0.27616320 red -1.00234243 -0.79328309 red 3 -0.88272375 -0.42375566 red -1.31503261 -0.04570735 red 4 1.37368014 -0.63154987 red -1.40635604 1.50906371 red 5 0.66810230 -0.43453383 red 0.30449564 -0.24893343 red 6 -0.06403118 -1.59095216 blue 0.41945472 0.09143192 blue 7 0.02208197 1.70299530 blue -1.64188953 -0.30545702 blue 8 -1.13057000 -0.67610437 blue -1.15801044 1.17682587 blue 9 -2.32315433 -0.07500192 blue 0.03576081 -1.14670543 blue 10 -0.64734307 0.74789423 blue -0.57466841 -1.69753353 blue You could also use cbind(). The second could be: ## need to provide the same variables names for matching columns names(dat2) <- c("var1", "var2", "var3") rbind(dat1, dat2) var1 var2 var3 1 -1.61397560 -0.40296928 red 2 1.01901681 -0.27616320 red 3 -0.88272375 -0.42375566 red 4 1.37368014 -0.63154987 red 5 0.66810230 -0.43453383 red 6 -0.06403118 -1.59095216 blue 7 0.02208197 1.70299530 blue 8 -1.13057000 -0.67610437 blue 9 -2.32315433 -0.07500192 blue 10 -0.64734307 0.74789423 blue 11 1.48380888 1.35501273 red 12 -1.00234243 -0.79328309 red 13 -1.31503261 -0.04570735 red 14 -1.40635604 1.50906371 red 15 0.30449564 -0.24893343 red 16 0.41945472 0.09143192 blue 17 -1.64188953 -0.30545702 blue 18 -1.15801044 1.17682587 blue 19 0.03576081 -1.14670543 blue 20 -0.57466841 -1.69753353 blue HTH G> > > Med venlig hilsen / Regards > > Joo Fadista > Ph.d. studerende / Ph.d. student > > > > AARHUS UNIVERSITET / UNIVERSITY OF AARHUS > Det Jordbrugsvidenskabelige Fakultet / Faculty of Agricultural Sciences > Forskningscenter Foulum / Research Centre Foulum > Genetik og Bioteknologi / Dept. of Genetics and Biotechnology > Blichers All 20, P.O. BOX 50 > DK-8830 Tjele > > Tel: +45 8999 1900 > Direct: +45 8999 1900 > Mobile: +45 > E-mail: Joao.Fadista at agrsci.dk <mailto:Joao.Fadista at agrsci.dk> > Web: www.agrsci.dk <http://www.agrsci.dk/> > ________________________________ > > Tilmeld dig DJF's nyhedsbrev / Subscribe Faculty of Agricultural Sciences Newsletter <http://www.agrsci.dk/user/register?lan=dan-DK> . > > Denne email kan indeholde fortrolig information. Enhver brug eller offentliggrelse af denne email uden skriftlig tilladelse fra DJF er ikke tilladt. Hvis De ikke er den tiltnkte adressat, bedes De venligst straks underrette DJF samt slette emailen. > > This email may contain information that is confidential. Any use or publication of this email without written permission from Faculty of Agricultural Sciences is not allowed. If you are not the intended recipient, please notify Faculty of Agricultural Sciences immediately and delete this email. > > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at stat.math.ethz.ch 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.-- %~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~% Gavin Simpson [t] +44 (0)20 7679 0522 ECRC [f] +44 (0)20 7679 0565 UCL Department of Geography Pearson Building [e] gavin.simpsonATNOSPAMucl.ac.uk Gower Street London, UK [w] http://www.ucl.ac.uk/~ucfagls/ WC1E 6BT [w] http://www.freshwaters.org.uk/ %~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%
?rbind rbind(df1, df2) This is a very basic question. You probably would save a lot of time if you read some of the documentation on the CRAN site (not the home R page). Click on "Contributed" on the left side of the screen and have a look at some of the documentation there. There are some excellent materials there. I'd recommend perhaps looking at ?Simple R? by John Verzani and ?A Guide for the Unwilling S User? by Patrick Burns. R and S are basically equivalent for this purpose. Good luck and don't forget to read the posting guide. --- Jo?o Fadista <Joao.Fadista at agrsci.dk> wrote:> Dear all, > > I would like to know how can I concatenate 2 > data.frames into a single one. Both data frames have > the same number of columns and the same class type > in each correspondent column. So what I want is to > have a new data.frame where I have first the values > from one data.frame and then the values from a > second data.frame would came after in this new > data.frame. > > Thanks in advance. > > > Med venlig hilsen / Regards > > Jo?o Fadista > Ph.d. studerende / Ph.d. student > > > > AARHUS UNIVERSITET / UNIVERSITY OF AARHUS > Det Jordbrugsvidenskabelige Fakultet / Faculty of > Agricultural Sciences > Forskningscenter Foulum / Research Centre Foulum > Genetik og Bioteknologi / Dept. of Genetics and > Biotechnology > Blichers All? 20, P.O. BOX 50 > DK-8830 Tjele > > Tel: +45 8999 1900 > Direct: +45 8999 1900 > Mobile: +45 > E-mail: Joao.Fadista at agrsci.dk > <mailto:Joao.Fadista at agrsci.dk> > Web: www.agrsci.dk <http://www.agrsci.dk/> > ________________________________ > > Tilmeld dig DJF's nyhedsbrev / Subscribe Faculty of > Agricultural Sciences Newsletter > <http://www.agrsci.dk/user/register?lan=dan-DK> . > > Denne email kan indeholde fortrolig information. > Enhver brug eller offentligg?relse af denne email > uden skriftlig tilladelse fra DJF er ikke tilladt. > Hvis De ikke er den tilt?nkte adressat, bedes De > venligst straks underrette DJF samt slette emailen. > > This email may contain information that is > confidential. Any use or publication of this email > without written permission from Faculty of > Agricultural Sciences is not allowed. If you are not > the intended recipient, please notify Faculty of > Agricultural Sciences immediately and delete this > email. > > > > [[alternative HTML version deleted]] > > > ______________________________________________ > R-help at stat.math.ethz.ch 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. >