Quick tip please!
Maybe data.frame(d1,d2[!names(d2) %in% names(d1)]) ?
On Tue, 17 Dec 2002 Ted.Harding at nessie.mcc.ac.uk wrote:
I have two CSV files (exported from Excel), say file1 and file2. The have the same number of rows, and each has several columns, with names on the first line; and some of the columns in file1 are repeated in file2. Using the "foreign" package, I can read these in separately to dataframes say d1 and d2 with
> d1<-read.csv("file1")
> d2<-read.csv("file2")
Now I would like to combine these into a single dataframe D, notionally D <- "d1 on the left, d2 on the right" which contains all the columns except that duplicates only occur once (and, preferably, in the order of occurrence on d1 -- i.e. remove them from d2 if already dound in d1). Any tips for how to do this slickly? With thanks, Ted. -------------------------------------------------------------------- E-Mail: (Ted Harding) <Ted.Harding at nessie.mcc.ac.uk> Fax-to-email: +44 (0)870 167 1972 Date: 17-Dec-02 Time: 15:47:27 ------------------------------ XFMail ------------------------------
______________________________________________ R-help at stat.math.ethz.ch mailing list http://www.stat.math.ethz.ch/mailman/listinfo/r-help
318 Carr Hall bolker at zoo.ufl.edu Zoology Department, University of Florida http://www.zoo.ufl.edu/bolker Box 118525 (ph) 352-392-5697 Gainesville, FL 32611-8525 (fax) 352-392-3704