[R] Merging files

David Winsemius dwinsemius at comcast.net
Tue Apr 27 20:51:27 CEST 2010


On Apr 27, 2010, at 1:19 PM, Alex Jameson wrote:

> This is a more detailed description of the problem,
>
> I have written the following lines of code to read the files
>
> data1=("c:\\mydata\\file1.txt")
> data2=("c:\\mydata\\file2.txt")

NONONO. Read the manual again. Perhaps:

data1 <- read.table("c:\\mydata\\file1.txt")
data2 <- read.table("c:\\mydata\\file2.txt")
>
> file 1 has fields like patientID, Name which are common in file2,  
> however
> not all fields are common
>
> i would like to create file3.txt with the merged data fields,

And what might happen happened when you tried:

merg12 <- merge(data1, data2)

??? ...  by default it would merge on the field names (actually column  
names in R-parlance) that were shared by the two dataframes.

-- 
David
>
> i hope this is clear, and i thank everyone, who has responded so far.
>
>
> Alex Jameson
> Student,
> University of Colorado
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org 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.



More information about the R-help mailing list