[R] Quick tip please!

Ulises Mora Alvarez umalvarez at fata.unam.mx
Tue Dec 17 17:46:03 CET 2002


Ted:

Take a look at ?merge

Good look

 

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
> 

-- 
Ulises M. Alvarez
LAB. DE ONDAS DE CHOQUES 
FISICA APLICADA Y TECNOLOGIA AVANZADA
UNAM
umalvarez at fata.unam.mx




More information about the R-help mailing list