Re: [R] How to add some of data in the first place dataset

From: Henric Nilsson <henric.nilsson_at_statisticon.se>
Date: Thu 28 Apr 2005 - 00:21:50 EST

Muhammad Subianto said the following on 2005-04-27 15:48:
> Dear R-help,
> First I apologize if my question is quite simple.
> I need add some of data in the first place my dataset, how can I do that.
> I have tried with rbind, but I did not succes.

Can you send a reproducible example where rbind didn't succeed?

> 0.1 3.6 0.4 0.9 rose
> 4.1 4.0 1.2 1.2 rose
> 4.4 3.2 1.9 0.5 rose
> 4.6 1.1 1.1 0.2 rose
> For example,
> > data(iris)
> > iris[1:10,]
> Sepal.Length Sepal.Width Petal.Length Petal.Width Species
> 1 5.1 3.5 1.4 0.2 setosa
> 2 4.9 3.0 1.4 0.2 setosa
> 3 4.7 3.2 1.3 0.2 setosa
> 4 4.6 3.1 1.5 0.2 setosa
> 5 5.0 3.6 1.4 0.2 setosa
> 6 5.4 3.9 1.7 0.4 setosa
> 7 4.6 3.4 1.4 0.3 setosa
> 8 5.0 3.4 1.5 0.2 setosa
> 9 4.4 2.9 1.4 0.2 setosa
> 10 4.9 3.1 1.5 0.1 setosa

Assume that you have the new data in a `data.frame', e.g.

 > (new.data <- read.table("clipboard", header = FALSE, col.names = c("Sepal.Length", "Sepal.Width", "Petal.Length", "Petal.Width", "Species")))

   Sepal.Length Sepal.Width Petal.Length Petal.Width Species

1          0.1         3.6          0.4         0.9    rose
2          4.1         4.0          1.2         1.2    rose
3          4.4         3.2          1.9         0.5    rose
4          4.6         1.1          1.1         0.2    rose

Then,

add.data <- rbind(new.data, iris)

will do the trick. Confirm this by

 > add.data[1:10, ]

     Sepal.Length Sepal.Width Petal.Length Petal.Width Species
1            0.1         3.6          0.4         0.9    rose
2            4.1         4.0          1.2         1.2    rose
3            4.4         3.2          1.9         0.5    rose
4            4.6         1.1          1.1         0.2    rose
151          5.1         3.5          1.4         0.2  setosa
210          4.9         3.0          1.4         0.2  setosa
310          4.7         3.2          1.3         0.2  setosa
410          4.6         3.1          1.5         0.2  setosa
5            5.0         3.6          1.4         0.2  setosa
6            5.4         3.9          1.7         0.4  setosa

HTH,
Henric

> >
> The result something like this,
>
> 0.1 3.6 0.4 0.9 rose
> 4.1 4.0 1.2 1.2 rose
> 4.4 3.2 1.9 0.5 rose
> 4.6 1.1 1.1 0.2 rose
> 5.1 3.5 1.4 0.2 setosa
> 4.9 3.0 1.4 0.2 setosa
> 4.7 3.2 1.3 0.2 setosa
> 4.6 3.1 1.5 0.2 setosa
> 5.0 3.6 1.4 0.2 setosa
> 5.4 3.9 1.7 0.4 setosa
> 4.6 3.4 1.4 0.3 setosa
> 5.0 3.4 1.5 0.2 setosa
> 4.4 2.9 1.4 0.2 setosa
> 4.9 3.1 1.5 0.1 setosa



R-help@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 Received on Thu Apr 28 00:32:04 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:31:27 EST