Re: [R] Add Columns and Order for Rbind?

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Wed 01 Jun 2005 - 03:04:08 EST

On 5/31/05, khobson@fd9ns01.okladot.state.ok.us <khobson@fd9ns01.okladot.state.ok.us> wrote:
>
>
>
>
> I am using rbind to add one list with one row to another master list. The
> problem is that not all columns exist in both lists.
>
> What methods would you recommend to reorder one list based on the column
> names of another? If both sets have the same order and columns, I can
> then use rbind. I can live with columns being added to the master list set
> it makes the task easier using something like union for column name
> matching and order.
>

Suppose we have this test data:

# test data
irish <- head(iris)
one.row <- data.frame(Sepal.Length = 5, Sepal.Area = 10)

# Then we rbind an NA row to irish and fill it with one.row

irish <- rbind(irish, NA)
irish[nrow(irish),names(one.row)] <- one.row

# If you don't want columns added to the master list do this instead:

irish <- head(iris) # recreate test data irish <- rbind(irish, NA)
both <- intersect(names(irish), names(one.row)) irish[nrow(irish), both] <- one.row[,both]

Note that appending rows one at a time can be slow.



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 Wed Jun 01 03:10:52 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:32:17 EST